First, second, and third normal forms


	Lesson 12 First, second, and third normal forms Conclusion
		This module covered database normalization up to 2NF. It identified the requirements of, and procedures for reaching, 1NF and 2NF. Along the way, it introduced the concepts of normalization, repeating groups, and functional dependencies. Having completed this module, you should now be able to: Define normalization normalization: The process of applying increasingly stringent rules to a relational database to correct any problems associated with poor design. Explain requirements for first normal form (1NF) first normal form (1NF): A table is in first normal form if it contains no repeating groups. Describe the limitations of 1NF Identify repeating groups: When an attribute has more than one value in a table row it is called repeating groups . Explain the requirements for second normal form (2NF) Second normal form (2NF): A table is in second normal form when every attribute is functionally dependent on the entire primary key. Identify functional dependency: A one-way relationship between two attributes so that, for any unique value of one attribute, there is only one value of the other attribute. Describe the limitations of 2NF Glossary terms normalization: The process of applying increasingly stringent rules to a relational database to correct any problems associated with poor design. First normal form (1NF): A table is in first normal form if it contains no repeating groups. repeating groups second normal form (2NF) functional dependency multi-field determinant concatenated primary key Requirements Analysis normal form denormalization The next module describes third normal form. Normalization - Quiz Before you move on to the next module, take the following quiz to check your knowledge of normalization to 2NF. Normalization - Quiz