Page 12 of 13PREVNEXT

Design the tables for a new database

Test yourself

Complete the following test so you can be sure you understand the material. Your answers are private, and test results are not scored.

What is the function of a primary key?

To uniquely identify each record in a table.

To encrypt and decrypt your database.

To help ensure you enter data in the correct table.

A good database design helps ensure that your data is:

Always backed up.

Complete and accurate.

Duplicated so it's easier to find.

You should always place all your data in separate tables.



How many tables should a well-designed database contain?

As many as necessary to capture all your data without redundancy.



You establish a relationship between Table A and Table B by:

Merging Table A with Table B.

Linking Table A with Table B.

Adding the primary key from Table A to Table B (or vice-versa).

This course has explained everything you need to know about database design



Page 12 of 13PREVNEXT