Normalisation (1NF–BCNF) — Concept Check
Questions on Normalisation (1NF–BCNF). 1NF eliminates repeating groups; 2NF removes partial dependencies; 3NF removes transitive dependencies; BCNF handles overlapping candidate keys — normalise for write integrity.
Questions in this quiz
8 questions on Normalisation (1NF–BCNF) — Concept Check. Work through them here, then start the quiz to answer them and see your score.
1.A database table has a column storing values like 'apple,banana,orange'. Which normal form is violated?
- A1NF
- B2NF
- C3NF
- DBCNF
2.A table with a composite primary key (order_id, product_id) stores product_name. What should be done?
- AKeep product_name in the current table
- BMake product_name part of the primary key
- CCreate a separate table for order details
- DMove product_name to a Products table
3.An orders table has columns zip_code and city, with city depending on zip_code. What is violated?
- A3NF
- B1NF
- CBCNF
- D2NF
4.In a database, a student can have one advisor per subject, but each advisor specializes in one subject. Which normal form is likely violated?
- A1NF
- BBCNF
- C3NF
- D2NF
5.A table with multiple overlapping candidate keys has a non-trivial dependency where the determinant is not a candidate key. Which form is violated?
- A2NF
- B1NF
- CBCNF
- D3NF
6.Which normal form ensures no non-key column depends on another non-key column?
- A3NF
- BBCNF
- C2NF
- D1NF
7.A table with a composite primary key has a column that depends only on part of the key. What is violated?
- A3NF
- B1NF
- CBCNF
- D2NF
8.A database is denormalized to improve read performance. What is the trade-off?
- AImproved write performance
- BIncreased redundancy
- CSimpler schema design
- DReduced data integrity