Q1easy
What is a Multi-valued Dependency (MVD), which is the focus of 4NF?
Back to Database Management Systems
20 Questions Total
Database Design & Normalization MCQs
Topic-wise practice questions for Database Management Systems. Test your knowledge, check solutions on demand, and pace your preparation.
Zero-leak answer engine • Rate-limited explanations
Practice in Timed ModeQ2medium
Given the relation R(A, B, C) and FDs: {A → B, B → A, B → C}. Which of the following is a Candidate Key?
Q3easy
How many candidate keys exist for R(A, B, C) if the FDs are {A → B, B → C, C → A}?
Q4easy
A relation R(P, Q, R, S, T) has FDs: {P → Q, RS → T, Q → S}. What is the closure {P, R}+?
Q5medium
In an Orders table, if deleting a single customer's last order also results in the database losing all of that customer's contact information (because it was only stored in the order record), what anomaly has occurred?
Q6medium
Examine the following SQL table definition. Why does this table violate 1NF (First Normal Form)?
Q7hard
Why is Dependency Preservation an important goal during normalization?
Q8hard
What is the key difference between 3NF and BCNF?
Q9hard
If a relation is in BCNF, which of the following is also guaranteed to be TRUE?
Q10medium
In a table with a composite primary key (OrderID, ProductID), a non-prime attribute OrderDate depends only on OrderID. Which normal form is being violated?