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

  • Thread starter Thread starter shivajikobardan
  • Start date Start date
Click For 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?
 
I have a question that I couldn’t fully understand its logic. The professor asked us to calculate the shear resistance and moment about the X and Y axis, using the given cross-section and the values of compressive and tensile stresses. I understand how to get the moment, but I’m confused about how to find the shear resistance from these stresses. Could you explain or clarify the method?

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