• Unit 7: Introduction to Data Normalization

    In this course, we have learned that entities in a database can be thought of as logical tables. Data in a table must be stored in a normalized way. First, we will identify the properties of a normalized table, learning about the process of normalization and its importance to the structure of a database. We will then study the four major steps of normalization and discuss the database anomalies that can result in the absence of normalization. Data normalization is the process of writing the data so that data redundancy is reduced and data integrity is increased.

    Completing this unit should take you approximately 4 hours.

    • 7.1: Defining Normalization

    • 7.2: Anomalies

    • 7.3: Functional Dependencies

    • 7.4: From 1NF to BCNF

    • Unit 7 Assessment