CS 374: Database Systems
James Madison University, Spring 2022

Feb 01: Relational Model, Key Constraints

Lesson Outline

25 min Lecture Slides
* Relational, XML, and JSON
* Constraints: KEY, CHECK, etc.
15 min Group Activity
* Design a "zoo" database
* Primary & foreign keys
* Additional constraints
20 min Textbook Slides
* Chapter 6, slides 49–89
15 min Group Activity
* Mapping EER to Relational

Before Tuesday

  1. Textbook: Read PDBM 6.3--6.4 (17 pages).

  2. Homework: Look at HW3 (will be extended).

  3. Project: Start thinking of ideas with your team!