Database Design for Mere Mortals™: A Hands-On Guide to Relational Database Design, Second Edition

Chapter 7

1. You identify and establish tables for the new database using the preliminary table list.

2. You use the preliminary field list to help you define tables for the database because the fields on the list may imply subjects that the database needs to track.

3. When an item on the list of subjects and a differently named item on the preliminary table list both represent the same subject, you select the name that best represents the subject and use it as the sole identifier for that subject.

4. The final table list provides the name, type, and description of each table in the database.

5. These are the guidelines for creating table names:

   a. Create a unique, descriptive name that is meaningful to the entire organization.

   b. Create a name that accurately, ...