Example & Tutorial understanding programming in easy ways.

What is second normal form?

Basically, we can say the table is in 2NF if:

- table is in 1NF

- and there is no partial dependency.

Partial dependency:

When any prime attribute instead of candidate key defines the Non prime attribute then it is called partial dependency.