Pahina 12 sa 13NAKALIPASSUSUNOD

Design the tables for a new database

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.

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

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

True.

False

Pahina 12 sa 13NAKALIPASSUSUNOD