Anomalies in a Relation (review)
An anomaly is a weakness in the way a relation is set up
Assume a single table representing student-courses (!)
Consider the following table:
Id Name Major Course-Id Course-Desc
45 Meyer CS CSE421 Operating Systems
56 Beaver CE CSE462 Database Concepts
23 Teller CE CSE506 Architecture
This table has all three anomalies: insert, update, and delete