Fundamentals of Database Systems (Midterm Examination)

Full Name (First Name, Middle Initial, Surname)

1. What does DBMS stand for?

• Database Managing Software
• Database Management System
• Data Backup Management Setup
• Database Modular System

2. Which of the following best defines “data”?

• Organized facts ready for analysis
• Raw facts and figures without meaning
• Processed information
• A database record

3. A collection of related data organized for easy access is called a:

• Record
• File
• Database
• Folder

4. A database suddenly fails to store any new entries because the physical disk crashed. Which component of the database system is most directly involved in this issue?

• Software
• People
• Hardware
• Procedures

5. A school registrar uses a DBMS to update student grades and print reports quickly. Based on this scenario, what function of the DBMS is being demonstrated?

• Simple data storage
• Efficient and secure data management
• Software replacement
• Hardware creation

6. What is the main purpose of an Entity-Relationship Diagram (ERD)?

• To represent how data flows between users and the internet
• To visually model the structure and relationships of data in a database
• To perform normalization on database tables
• To convert database tables into reports

7. Which of the following best defines an entity in an ER model?

• A unique identifier of data
• A characteristic or property of an object
• An object or concept that can have data stored about it
• A relationship between two attributes

8. In an ER diagram, what symbol is commonly used to represent a relationship between entities?

• Rectangle
• Oval
• Diamond
• Arrow Line

9. Which attribute uniquely identifies a record in a table?

• Composite key
• Foreign key
• Secondary key
• Primary key