First second and third normal form
by Mike_B
After completing the lessons in this module, you should be able to: Define the concept of normalization. Explain the requirements for first normal form (1NF) Identify repeating groups. Explain the requirements for second normal form (2NF) Identify functional dependencies. Describe the limitations of 2NF. The next lesson introduces normalization. 2NF. Second Normal Form “No Partial Dependencies”. This is only applicable if the table contains a composite key. The database must be in First Normal Form. All columns within a table must depend on the whole key (No partial Dependency). 3NF. Third Normal Form “No Transitive Dependencies”. The database must be in Second Normal Form. A relation is in second normal form if it is in 1NF and every non-key attribute is fully functionally dependent on the primary key. (i.e. 2NF = 1NF + no partial dependencies). The whole key. A relation is in third normal form if it is in 2NF and there are no dependencies between non-key attributes. (i.e. 2NF + no transitive dependencies). And. Read more