what is the difference between the first second and third normal form?
First normal form enforces these criteria: ... Second normal form = 1NF + no partial dependencies i.e. All non-key attributes are fully functional dependent on the primary key. Third normal form = 2NF + no transitive dependencies i.e. All non-key attributes are fully functional dependent DIRECTLY only on the primary key.