The translation of a conceptual data model – such as an ER diagram – into a practical, performant database follows a well-defined set of rules for most entities and their relationships. Data normalization ensures that the resulting relations are free of redundancy.

Learning Objectives

  • Describe the following terms:
    • data normalization
    • functional dependency
  • Create a normalized relational database schema from an entity-relationship (ER) diagram

How to Complete this Lesson

Complete the following learning activities: (4.75–5 hours total)

  1. Read Fundamentals of Database Management Systems Chapter 7: Logical Database Design (75 minutes)
  2. Attend the class meeting (60 minutes)
  3. Take the quiz (10 minutes)
  4. Work on the Microsoft Access programming exercise (PEX) (60 minutes)
  5. Start the optional homework on the relational model (75–90 minutes minutes)

Due

As a reminder, the following is due this lesson:

« Relational Data Model Normal Forms II »