Skip to content

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]

Lecture Slides [30 min]

Group Activity [30 min]

Your To-Do List

  • Finish reading zyBook sections 5.15.2
  • Read zyBook sections 3.103.12
  • Continue working on GP2 (due Monday)