What Is 3nf?

1.	What Is 3nf?
Answer» A RELATION SCHEMA R is in 3NF if it is in 2NF and for EVERY FD X A EITHER of the following is true X is a Super-key of R. A is a prime attribute of R. In other words, if every non prime attribute is non-transitively dependent on primary key. A relation schema R is in 3NF if it is in 2NF and for every FD X A either of the following is true In other words, if every non prime attribute is non-transitively dependent on primary key.

Answer»

A RELATION SCHEMA R is in 3NF if it is in 2NF and for EVERY FD X A EITHER of the following is true

In other words, if every non prime attribute is non-transitively dependent on primary key.

A relation schema R is in 3NF if it is in 2NF and for every FD X A either of the following is true

In other words, if every non prime attribute is non-transitively dependent on primary key.

Discussion