Lecture 4. Schema normalization
Readings:
- The reading for this lecture is Chapter 19 ("Schema Refinement and Normal Forms") of Ramakrishnan and Gehrke. Third Ed.
Even though the reading comes from the book, we would still like you to submit a review because reviews are a great way to prepare for lecture. As you read this chapter, consider the following questions:
- What is a functional dependency?
- How are functional dependencies helpful when refining the schema of a relation?
- What anomalies can occur in a relation in 3NF that cannot occur in a relation in BCNF?
- Why is 3NF sometimes preferable to BCNF?
Lecture notes:
Additional resources:
- Chapter 2 in the R&G book.