Mar 19: Functional Dependencies
Learning Objectives
After today's class, you should be able to:
- Explain anomalies that can occur when redundant data is stored.
- Give everyday examples of functional dependencies in databases.
Lesson Outline¶
Exam Debrief [15 min]
- See the Sample Solution on Canvas
- Reminder: Gradescope shows the full rubric
- Even if specific items don't apply to you
Lecture Slides [40 min]
- Functional Dependencies
- Includes three short exercises
Project Overview [20 min]
- GP1: Hotel ER Modeling
- Finalize teams by Thursday
- Need to select a team name