🎙 Free live masterclass · Sun, 29 Nov, 7:00 pm IST · Java Full Stack roadmap Register free →
Skills101
← Quiz: Normalization: all 10 questions

Quiz: Normalization · Question 2 of 10

Key (orderid, productid); column customername depends only on orderid. This violates:

Key (order_id, product_id); column customer_name depends only on order_id. This violates:

  1. A.1NF
  2. B.2NF
  3. C.3NF
  4. D.Nothing
Answer & explanation

Correct answer: 2NF

A non-key column depending on part of a composite key is a partial dependency (2NF).

Can you get the rest right without peeking?

Take the timed Quiz: Normalization quiz free. Pass it to earn XP and count towards your certificate.

Start the quiz →