Database Modeling and Design MCQs with Answers
Practice important Database Modeling and Design MCQs with answers and explanations.
Multiple Choice Questions
Q131: What is an example of a primary key for the Apartment entity?
- A: Apartment ID
- B: Building Name
- C: Covered Area
- D: Rent
View Answer
A
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
View Answer
A
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
View Answer
C
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
View Answer
A
Q135: Which attribute is a candidate key in the Customer entity?
- A: CNIC
- B: Name
- C: Rent
- D: Phone Number
View Answer
A
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
View Answer
A
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
View Answer
B
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
View Answer
C
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
View Answer
A
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
View Answer
C