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
- Read Fundamentals of Database Management Systems Chapter 7: Logical Database Design (75 minutes)
- Attend the class meeting
- Complete the handout
Due
As a reminder, the following is due this lesson: