Database Modeling and Design MCQs with Answers
Practice important Database Modeling and Design MCQs with answers and explanations.
Chapter: 8
Q121:
In an ERD, what does an entity represent?
A. An attribute
B. A property
C. A real-world object
D. A process
Correct Answer:
C
Chapter: 8
Q122:
What is an attribute in the context of an ERD?
A. A relationship between entities
B. A property of an entity
C. A class in a database
D. A graphical representation
Correct Answer:
B
Chapter: 8
Q123:
What is the smallest storage unit of any database?
A. Column
B. Entity
C. Attribute
D. Row
Correct Answer:
C
Chapter: 8
Q124:
What is the purpose of relationships in an ERD?
A. To describe entities
B. To connect data among entities
C. To visualize attributes
D. To store data
Correct Answer:
B
Chapter: 8
Q125:
In a school database, which of the following can be considered an entity?
A. Exams
B. Timetable
C. Student
D. Attendance
Correct Answer:
C
Chapter: 8
Q126:
The word "entity" is derived from the Latin word "en," meaning ______.
A. being
B. existence
C. life
D. object
Correct Answer:
A
Chapter: 8
Q127:
What is an entity set?
A. A collection of similar types of entities
B. A single attribute
C. A data model
D. A database design
Correct Answer:
A
Chapter: 8
Q128:
What is the function of an Entity-Relationship Diagram (ERD)?
A. Visualizes the business data
B. Defines system processes
C. Stores large amounts of data
D. Executes business logic
Correct Answer:
A
Chapter: 9
Q129:
What does an Entity Relationship Diagram (ERD) represent in database design?
A. Entity, Relationship, and Attributes types
B. Logic gates
C. Arithmetic operations
D. Sorting algorithms
Correct Answer:
A
Chapter: 9
Q130:
Which of the following is an entity in the building apartment renting scenario?
A. FLOOR
B. DOOR
C. CEILING
D. CUSTOMER
Correct Answer:
D
Chapter: 9
Q131:
What is an example of a primary key for the Apartment entity?
A. Apartment ID
B. Building Name
C. Covered Area
D. Rent
Correct Answer:
A
Chapter: 9
Q132:
Which of the following is a valid super key for the Building entity?
A. (Building Name, Address)
B. Building Name
C. Address
D. Phone Number
Correct Answer:
A
Chapter: 9
Q133:
The minimal number of attributes that can uniquely identify a row in a table is called:
A. Primary key
B. Super key
C. Candidate key
D. Foreign key
Correct Answer:
C
Chapter: 9
Q134:
What does the primary key ensure in a relational table?
A. Unique identification of each row
B. Non-unique values
C. Grouped values
D. Duplicated entries
Correct Answer:
A
Chapter: 9
Q135:
Which attribute is a candidate key in the Customer entity?
A. CNIC
B. Name
C. Rent
D. Phone Number
Correct Answer:
A
Chapter: 9
Q136:
In the database design, what is a foreign key used for?
A. To create relationships between tables
B. To uniquely identify records in a table
C. To handle NULL values
D. To define the primary key
Correct Answer:
A
Chapter: 9
Q137:
In which relationship does every instance of one entity link to many instances of another?
A. One-to-One
B. One-to-Many
C. Many-to-One
D. None
Correct Answer:
B
Chapter: 9
Q138:
In a One-to-Many relationship, the primary key of the parent table acts as a:
A. Composite Key
B. Super Key
C. Foreign Key
D. Unique Key
Correct Answer:
C
Chapter: 9
Q139:
Which type of key uniquely identifies each row in a table?
A. Primary Key
B. Composite Key
C. Minimal Super Key
D. None of the above
Correct Answer:
A
Chapter: 9
Q140:
A customer renting multiple apartments from the same building represents which type of relationship?
A. One-to-One
B. Many-to-One
C. One-to-Many
D. Many-to-Many
Correct Answer:
C