2NF Second Normal Form in RDBMS

2NF Second Normal Form in RDBMS

2NF Second Normal Form
A relation R is said to be in 2NF if it is in 1NF and there should not be any partial dependency.

Here all the non key attributes are dependent on the key alone. No  attribute is depend upon a part of the key.

Any relation having a key with single attribute is in 2NF.

 

Partial dependency in RDBMS

Partial dependency exist if any non key attribute functionally depend upon a part of the key.