Database Modeling and Design MCQs with Answers
Practice important Database Modeling and Design MCQs with answers and explanations.
Multiple Choice Questions
Q161: In EERD, every instance of the super type is also an instance of:
- A: A different super type
- B: None of the subtypes
- C: Only one subtype
- D: Multiple subtypes
View Answer
C
Q162: In an ERD, which model shows foreign keys and attributes?
- A: Conceptual Data Model
- B: Logical Data Model
- C: Physical Data Model
- D: Abstract Data Model
View Answer
C
Q163: What type of relationship requires a new third table with primary keys as foreign keys?
- A: One-to-Many
- B: Many-to-Many
- C: One-to-One
- D: Many-to-One
View Answer
B
Q164: In the Physical Data Model, which table would likely have a composite primary key?
- A: Floor
- B: Building
- C: Customer
- D: Apartment
View Answer
A
Q165: For a One-to-One relationship, where will the foreign key be placed?
- A: In the parent table
- B: In the child table
- C: In a third table
- D: In both tables
View Answer
B
Q166: In the Building-Apartment scenario, which entity has attributes including Building Name and Address?
- A: Floor
- B: Customer
- C: Building
- D: Apartment
View Answer
C
Q167: Fill in the blank: In the Physical Data Model, the foreign key for the Floor table is combined with ________ to form a composite primary key.
- A: Building Name
- B: Floor Number
- C: Apartment ID
- D: Customer ID
View Answer
B
Q168: In the Musical Bands scenario, what is the maximum number of songs that can be included in an Album?
- A: 5
- B: 8
- C: 10
- D: 12
View Answer
D
Q169: What is the primary key in the Writer_song table?
- A: sname
- B: wid
- C: sname and wid
- D: aname
View Answer
C
Q170: In the Airport Management System, which entity would you expect to have attributes like Flight ID and Date of Departure?
- A: Ticket
- B: Passenger
- C: Flight
- D: Plane
View Answer
C