A 3.2.6 Worksheet Answers
This is the "Before" state. Notice the non-atomic cells (multiple items) and the ambiguity you pointed out. The Goal: Atomicity (Atomic Data). The Action: We split the multiple values so that each cell contains only one value. We duplicate rows to preserve data. The Key: We identify a Composite Primary Key to uniquely identify each row: {StudentID, ClassID, ClubName}. Topic: A3.2.6 Constructing a database normalized...