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.
True.
False.
How many tables should a well-designed database contain?
As many as necessary to capture all your data without redundancy.
One, with many fields.
Two.
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).
