Chapter 8. Keys

   

---

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?
11:	State three of the Elements of the Ideal Field.
12:	Under what condition is redundant data acceptable?
13:	In general terms, what three steps do you follow to resolve a multivalued field?
14:	When is it necessary to use a duplicate field in a table?
15:	How can you refine table structures?
16:	State three of the Elements of the Ideal Table.
17:	What is a subset table?

---

Top