Database Design for Mere Mortals: A Hands-On Guide to Relational Database Design
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 |