← Quiz: Normalization: all 10 questions
Quiz: Normalization · Question 3 of 10
empid → deptid and deptid → deptname in one table. deptname violates:
emp_id → dept_id and dept_id → dept_name in one table. dept_name violates:
- A.1NF
- B.2NF
- C.3NF
- D.No rule
Answer & explanation
Correct answer: 3NF
dept_name depends on the key through another non-key column: a transitive dependency.
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 →