🎙 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 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:

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