← 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?
- A.The join fails with an error
- B.It produces a spurious row, such as an agent selling a product they do not sell
- C.It loses one of the original rows
- 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 →