Chapter 9. Field Specifications

   

---

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