← Quiz: Normalization: all 10 questions
Quiz: Normalization · Question 5 of 10
A table whose primary key is a single column is automatically in:
A table whose primary key is a single column is automatically in:
- A.BCNF
- B.2NF (if it is in 1NF)
- C.3NF
- D.No normal form
Answer & explanation
Correct answer: 2NF (if it is in 1NF)
Partial dependency needs a composite key, so a single-column key table in 1NF is in 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 →