Review Questions
State the three reasons why keys are important.
What are the four main types of keys?
What is the purpose of a candidate key?
State four items of the Elements of a Candidate Key.
True or False: A candidate key can be composed of more than one field.
Can a table have more than one candidate key?
What is an artificial candidate key?
What is the most important key you assign to a table?
Why is this key important?
How do you establish a primary key?
State four items of the Elements of a Primary Key.
What must you do before you finalize your selection of a primary key?
What is an alternate key?
What do you ensure by establishing table-level integrity?
Why should you review the initial table structures?