This chapter is from the book
- 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?