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

  • Thread starter Thread starter shivajikobardan
  • Start date Start date
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
The last two look like lookup tables to translate between sno and sname. Given sno I can find sname and given sname I can find sno.
 
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?
 

Similar threads

  • · Replies 2 ·
Replies
2
Views
1K
  • · Replies 2 ·
Replies
2
Views
2K
  • · Replies 3 ·
Replies
3
Views
2K
Replies
27
Views
7K
  • · Replies 2 ·
Replies
2
Views
4K
  • · Replies 14 ·
Replies
14
Views
6K
  • · Replies 19 ·
Replies
19
Views
3K
  • · Replies 6 ·
Replies
6
Views
2K
  • · Replies 4 ·
Replies
4
Views
3K
  • · Replies 13 ·
Replies
13
Views
7K