17
5
Concepts of Database Management, 4th Edition, Pratt & Adamski
Third Normal Form (3NF)
•2NF Tables may still contain problems
•Redundancy and wasted space
•Update Anomalies
•Update, inconsistent data, additions, deletions
•Occur because a column is dependent on a portion of a multi-column primary key
•
•--we won’t cover 4th & 5th normal forms since they are not often used.
•