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

  • Thread starter Thread starter shivajikobardan
  • Start date Start date
AI Thread Summary
The discussion centers on the conditions for a database schema to be in Third Normal Form (3NF), particularly examining the functional dependencies (FDs) involving Sno, Pno, Qty, and Sname. It is established that the left-hand side (LHS) of the FDs should be a super key, while the right-hand side (RHS) should contain non-prime attributes for 3NF compliance. The first two FDs meet these criteria, but the last two do not seem to conform, raising questions about their classification as 3NF. The conversation highlights the ambiguity in the data relationships, particularly regarding the uniqueness of Sname and its implications for 3NF. Ultimately, the complexity of the data context makes it challenging to definitively categorize the FDs without further information.
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
Views
1K
Replies
2
Views
1K
Replies
2
Views
4K
Replies
14
Views
6K
Replies
19
Views
3K
Replies
4
Views
3K
Replies
13
Views
7K
Back
Top