← 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:
- A.1NF
- B.2NF
- C.3NF
- 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 →