Database Design for Mere Mortals: A Hands-On Guide to Relational Database Design
Review Questions
| 1: | State two major reasons why field specifications are important. |
| 2: | What do you gain by establishing field-level integrity ? |
| 3: | What are the three categories of elements in a field specification? |
| 4: | Name the three types of specifications. |
| 5: | Why is it beneficial for you to compose a proper field description? |
| 6: | What does the Data Type element indicate ? |
| 7: | What does the Character Support element indicate? |
| 8: | What is the purpose of the Display Format element? |
| 9: | What types of keys are indicated on a field specification? |
| 10: | True or False: A null represents a blank value. |
| 11: | What is the significance of the Range of Values element? |
| 12: | What is the purpose of an Edit Rule? |
| 13: | What is the purpose of the Comparisons Allowed element? |
| 14: | What is a value expression ? |
| 15: | When do you use a generic specification? |
| |
| Top |