Sep 26: Normal Forms (3NF, BCNF)
Learning Objectives
After today's class, you should be able to:
- Define and explain 1NF, 2NF, 3NF, and BCNF.
- Given a relation (or dataset) and a set of functional dependencies, decompose into a set of relations in 3NF.
Lesson Outline¶
HW3 [5 min]
GP2 [10 min]
- GP2 – see example in profs repo
Lecture Slides [30 min]
Group Activity [30 min]