Skip to main content

CS403: Introduction to Modern Database Systems

Unit 7: Intro to Data Normalization
In this course, we have learned that entities in a database can be thought of as logical tables. We will now learn that data in a table must be stored in a normalized way. We will first 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.

Completing this unit should take you approximately 17 hours.
- Unit 7 Learning Outcomes Page
- 7.1: Normalization Defined
  - Gordon Russell's "Normalization"
    Read this chapter.
  - WingsLive: "What is Database Normalization?" Page
    Watch this video.
  - Art Langer's "Logic Data Modeling" Page
    Watch these videos.
- 7.2: Anomalies
  - Database Management: "Data Anomalies" URL
    Read this article.
- 7.3: Functional Dependencies
  - Stanford University: "Functional Dependencies" Page
    Watch this lecture.
- 7.4: From 1NF to BCNF
  - Gordon Russell's "Normalisation - BCNF" URL
    Read this chapter.
  - Gordon Russell's "Normalization Quiz" URL
    Answer questions 1-14.
  - Art Langer's "Normal Form" Page
    Watch these videos.