Concepts of Database Management, 4th Edition, Pratt & Adamski
Physical-Level
Design
•Undertaken after information-level design completion
•Most
DBMSs support primary, candidate, secondary, and foreign keys
•DB
programmers must include logic to ensure the uniqueness of primary keys and enforce other conditions