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: (3.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. Start the project proposal (60 minutes)

    • Meet with your team to discuss the project, including everyone’s expectations for contributions (30 minutes)

      It is recommended, but not required, for you to complete the project as part of a team. In practice, the individual workload for each member of a team is less than when working by yourself.

    • Write the section(s) of the proposal that are assigned to you (30 minutes)

  4. Take the quiz (10–12 minutes)

Due

As a reminder, the following is due this lesson:

Resources

« Relational Data Model

Normal Forms II »