Skip to content

Mar 21: Normal Forms (3NF and BCNF)

Learning Objectives

After today's class, you should be able to:

  • Summarize the process of designing a table in Third Normal Form.
  • Explain why/when you normalize, and why you might denormalize.

GP1 Follow-Up [10 min]

  • Review requirements, answer questions
  • Finalize group names (and usernames)

Lecture Slides [15 min]

Group Activity [35 min]

Working Time [15 min]

  • Coordinate project

Your To-Do List

  • Finish reading zyBook sections 4.104.12
  • Finish working on GP1 (due Monday)