Review Questions

1.

How do you identify and establish tables for the new database?

2.

Why do you use the preliminary field list to help you define tables for the database?

3.

What action do you take when an item on the list of subjects and a differently named item on the preliminary table list both represent the same subject?

4.

What information does the final table list provide?

5.

State three guidelines for creating table names.

6.

State two guidelines for composing table descriptions.

7.

How do you assign fields to a table on the final table list?

8.

State three guidelines for creating field names.

9.

What two problems can poorly designed fields cause?

10.

What can you use to resolve field anomalies? ...

Get Database Design for Mere Mortals™: A Hands-On Guide to Relational Database Design, Second Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.