First Normal Form(1NF) is a property of a relation in a relational database.
A relation is in First normal Form if and only if
the domain of each attribute contains only atomic values and the value of each attribute
contains only a single value from that domain.
A relation is in Second Normal Form(2NF) if it is in 1NF and every non-prime attribute of the relation is dependent on the whole of every candidate key.
Third Normal Form is the third step in normalizing a database and it builds on the first and second normal form(1NF & 2NF). 3NF states that,all column reference in referenced data that are not dependent on primary key should be removed.
A relation is in Second Normal Form(2NF) if it is in 1NF and every non-prime attribute of the relation is dependent on the whole of every candidate key.
Third Normal Form is the third step in normalizing a database and it builds on the first and second normal form(1NF & 2NF). 3NF states that,all column reference in referenced data that are not dependent on primary key should be removed.