[ Team LiB ] Previous Section Next Section

Workshop

The Workshop includes quiz questions that are designed to help you test your understanding of the material covered and activities to help put what you've learned to practice. You can find the answers to the questions in the section immediately following the quiz.

Quiz

1:

A composite key is always made up of more than one field (True/False).

A1:

True.

2:

Name three rules for creating a primary key.

A2:

You should make a primary key short, stable, simple.

3:

An AutoNumber field is an example of a natural key (True/False).

A3:

False. An AutoNumber field is a contrived key.

4:

Atomic means that information should appear in only one place (True/False).

A4:

False. Atomic means that each piece of data should be broken down as much as possible.

5:

When you are ready to implement an application, you should distribute the application to all your users.

A5:

False. When you are ready to implement an application, you should first distribute the application to a small group of users.

Activities

Practice applying the techniques that you learned in this hour to some task that you or a co-worker must perform at your office. Come up with the table structures necessary to support the development process. As you proceed through the hours that follow, continue to build this test application and try to find problems with the table design you have selected.

    [ Team LiB ] Previous Section Next Section