CS 374: Database Systems
James Madison University, Spring 2022

Feb 03: Dependencies and Normalization

Lesson Outline

20 min Group Project
* Create and share Overleaf project
* Brainstorm / discuss initial ideas
25 min Textbook Slides
* Chapter 6, slides 2–48
15 min Group Activity
* Primary and Foreign keys
* Unnormalized vs Normalized
15 min HW3 Examples
* Mapping (E)ER to Relational  [pdf]
* Normalization in 3NF/BCNF  [pdf]

Before Thursday

Next Tuesday is Assessment Day, so we won't have class. Good luck at the CISE Career and Internship Fair!

  1. Textbook: Read PDBM 6.1--6.2 (17 pages).

  2. Project: Write your GP1 proposal.
    * Bring three hard copies to class.

  3. Homework: Work on HW3 (extended to Sunday 2/13).