Learning Objectives

  • Define the following normal forms:
    • First (1NF)
    • Second (2NF)
    • Third (3NF)
  • Decompose a relational schema into 3NF based on the schema’s functional dependencies

How to Complete this Lesson

  1. Read Fundamentals of Database Management Systems Chapter 7: Logical Database Design (75 minutes)
  2. Attend the class meeting
  3. Complete the handout

Due

As a reminder, the following is due this lesson: