Solid Quality Learning, Microsoft Corporation Staff - Microsoft SQL Server 2005 Database Essentials Step by Step
| | ||
| | ||
| | ||
| 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. |
| | ||
| | ||
| | ||