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: (3.75–4 hours total)
- Attend the class meeting
(60 minutes)
- Complete the handout
- Complete the Microsoft Access programming exercise (PEX)
(90 minutes)
- Complete Creating Forms and Reports
- Complete the optional homework on the relational model (75–90 minutes minutes)
Due
As a reminder, the following is due this lesson: