Answer the question
In order to leave comments, you need to log in
What is the main difference between second normal form and third normal form?
Having shoveled 1.5 pages of search results, I came to the conclusion that both there and there, NOT the key attributes of the table should depend only on the Primary key. The only difference that I caught between them is that in 2nf a non-key attribute is irreducibly dependent on PK, and in 3nf the same non-key attribute is non-transitively dependent on PK. The difference is quite insignificant. Maybe I missed something, help me figure it out, eh?
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question