🎙 Free live masterclass · Sun, 29 Nov, 7:00 pm IST · Java Full Stack roadmap Register free →
Skills101
← Quiz: 4NF and 5NF: all 10 questions

Quiz: 4NF and 5NF · Question 9 of 10

In the agent–company–product example, why is joining only agentcompany and companyproduct not enough?

In the agent–company–product example, why is joining only agent_company and company_product not enough?

  1. A.The join fails with an error
  2. B.It produces a spurious row, such as an agent selling a product they do not sell
  3. C.It loses one of the original rows
  4. D.It changes the column names
Answer & explanation

Correct answer: It produces a spurious row, such as an agent selling a product they do not sell

All three projections are needed to remove the invented row.

Can you get the rest right without peeking?

Take the timed Quiz: 4NF and 5NF quiz free. Pass it to earn XP and count towards your certificate.

Start the quiz →