Database Design for Mere Mortals: A Hands-On Guide to Relational Database Design
Review Questions
| 1: | State the three reasons why keys are important. |
| 2: | What are the four main types of keys ? |
| 3: | What is the purpose of a candidate key ? |
| 4: | State four items of the Elements of a Candidate Key . |
| 5: | True or False: A candidate key can be composed of more than one field. |
| 6: | Can a table have more than one candidate key? |
| 7: | What is an artificial candidate key? |
| 8: | What is the most important key you assign to a table? |
| 9: | Why is this key important? |
| 10: | How do you establish a primary key ? |
| 11: | State four items of the Elements of a Primary Key . |
| 12: | What must you do before you finalize your selection of a primary key? |
| 13: | What is an alternate key ? |
| 14: | What do you ensure by establishing table-level integrity? |
| 15: | Why should you review the initial table structures? |
| |
| Top |