6
6
Concepts of Database Management, 4th Edition, Pratt & Adamski
Normalize the Tables
•Represent all keys
•Primary, alternate, secondary, foreign
•Database Design Language (DBDL)
•Mechanism for representing tables and keys
•Table name followed by columns in parentheses
•Primary key column(s) underlined
•AK identifies alternate keys
•SK identifies secondary keys
•FK identifies foreign keys
•