Chapter 5 Quick Reference

To	Do This
Increase the quality of the database design	Create three database models: conceptual, logical, and physical.
Communicate the database design and validate the model	Create an ER diagram.
Increase the performance of the application	Use the appropriate datatype for each column.
Ensure the integrity of the data stored in the database	Use database constraints such as NOT NULL, DEFAULT, PRIMARY KEY, UNIQUE, CHECK, and FOREIGN KEY.