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 ...

Get Database Design for Mere Mortals™: A Hands-On Guide to Relational Database Design, Second Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.