Multiple choice
A relational table is already in second normal form (2NF). What further condition must hold for it to be in third normal form (3NF)?
A
The table contains no foreign keys
B
Every field holds a single atomic value
C
No non-key attribute depends on only part of a composite key
D
No non-key attribute depends transitively on the primary key
Pick an answer to check
