Database Modeling and Design MCQs with Answers
Practice important Database Modeling and Design MCQs with answers and explanations.
Multiple Choice Questions
Q191: Fill in the blank: The process of normalization includes three steps known as ________.
- A: Normal Forms
- B: Data Integrity
- C: Indexing
- D: Entity Relationships
View Answer
A
Q192: What does the First Normal Form (1NF) ensure about rows in a table?
- A: They contain repeating groups
- B: Each row must be unique
- C: They must have multiple primary keys
- D: They can have duplicated data
View Answer
B
Q193: Which normal form is concerned with removing partial dependencies?
- A: First Normal Form (1NF)
- B: Second Normal Form (2NF)
- C: Third Normal Form (3NF)
- D: Fourth Normal Form (4NF)
View Answer
B
Q194: Fill in the blank: The Second Normal Form (2NF) requires that each non-key attribute should be ________ on the primary key.
- A: partially dependent
- B: fully dependent
- C: redundantly dependent
- D: conditionally dependent
View Answer
B
Q195: What is the main issue addressed by the Third Normal Form (3NF)?
- A: Redundancy in data
- B: Partial dependency
- C: Transitive dependency
- D: Incomplete dependency
View Answer
C
Q196: Fill in the blank: The Third Normal Form (3NF) removes transitive dependency by ensuring that non-prime attributes are only dependent on ________.
- A: other non-prime attributes
- B: the primary key
- C: partial keys
- D: foreign keys
View Answer
B
Q197: What happens if a table is in 2NF but not in 3NF?
- A: It is considered normalized
- B: It needs to be decomposed to remove transitive dependency
- C: It should be updated to a higher normal form
- D: It can be used as it is
View Answer
B
Q198: Fill in the blank: An example of a table that is not in 3NF would be one where the ________ is determined by another non-prime attribute.
- A: primary key
- B: total registered courses
- C: foreign key
- D: status
View Answer
D
Q199: Which table would NOT be considered in Third Normal Form (3NF)?
- A: Student table with primary key Sid and attributes Sname, Total_Registered_Courses
- B: Course table with attributes Cid, Cname, Credithrs
- C: Student-Status table with Total_courses_registered, Status
- D: Airport table with attributes aid, Flight#, gate#, aname, runway#
View Answer
D
Q200: Fill in the blank: In the normalization process, the table "Airport" was split into "Airport-Info" and "Airport" to address ________.
- A: redundancy
- B: partial dependency
- C: transitive dependency
- D: repeating groups
View Answer
B