Why Is Sno, Pno=>Qty, Sname=>Qty in 3NF?

  • Topic: Comp Sci 
  • Thread starter Thread starter shivajikobardan
  • Start date Start date
Join the discussion
Registration is free. Ask a follow-up in this thread, or start your own.
2 replies · 1K views
shivajikobardan
Messages
637
Reaction score
54
Homework Statement
3NF third normal form
Relevant Equations
none
Sno,Pno=>Qty
Sname,Pno=>Qty
Sno=>Sname
Sname=>Sno

To be in 3NF, LHS should be super key and RHS should be non-prime attribute.
It holds true for first 2 FDs. But for the last two, it doesn't hold true. So, why is it in 3NF?
chatGPT says it holds true for all FDs, but I can't see how.
 
Physics news on Phys.org
shivajikobardan said:
Homework Statement:: 3NF third normal form
Relevant Equations:: none

Sno,Pno=>Qty
Sname,Pno=>Qty
Sno=>Sname
Sname=>Sno
This is impossible to answer without knowledge of what data are contained in the columns, however assuming Sname represents a person's name, and given the fact that two people can have the same name what do you think about your statement that Sname,Pno=>Qty is in 3NF?