QuizzesNormalisation (1NF–BCNF) — Concept Check
intermediate
mysql

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.

8 minutes 8 questions Pass at 70%
Time Limit
8 minutes - timer starts when you begin
Change Answers Freely
Revisit and change any answer before submitting
Full Review After Submit
Correct answers and explanations shown for every question
Auto-submit on timeout
Quiz submits automatically when time runs out

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. 1.A database table has a column storing values like 'apple,banana,orange'. Which normal form is violated?

    • A1NF
    • B2NF
    • C3NF
    • DBCNF
  2. 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. 3.An orders table has columns zip_code and city, with city depending on zip_code. What is violated?

    • A3NF
    • B1NF
    • CBCNF
    • D2NF
  4. 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. 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. 6.Which normal form ensures no non-key column depends on another non-key column?

    • A3NF
    • BBCNF
    • C2NF
    • D1NF
  7. 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. 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