A
A
Arthur2016-11-17 15:48:01
Database design
Arthur, 2016-11-17 15:48:01

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

1 answer(s)
R
Rsa97, 2016-11-17
@Rsa97

The second form eliminates the dependence of non-key fields on part of the key.
Third normal form excludes non-key fields from being dependent on other non-key fields.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question