13
5
Concepts of Database Management, 4th Edition, Pratt & Adamski
Second Normal Form (2NF)
•1NF Tables may contain problems (refer to p. 147 text for full example)
•Redundancy
•Update Anomalies
•Update, inconsistent data, additions, deletions
•Occur because a column is dependent on a portion of a multi-column primary key
•2NF Table
•In 1NF +no non-key column is dependent on only a portion of the primary key
•