Normal Forms II

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

Complete the following learning activities: (2 hours total)

Attend the class meeting (60 minutes)
- Complete the handout
Complete the project proposal (60 minutes)
- Review the section(s) written by others
- Revise sections for consistent grammar, style, etc.

Due

As a reminder, the following is due this lesson:

Project: Proposal

Resources

Questions for logical database design (90–120 minutes)