Question

Which of the following are reasons for having a primary key?

All of the other answers are reasons for having a primary key.

A primary key identifies each record in the table.

Access responds faster to requests for specific records based on the primary key.

A primary key prevents duplicate values from being entered in the same field.

The ________________ is the name of the model used when designing databases.

Data Flow Diagram

Entity Relationship Diagram

Relative Model

Physical Model

____________ is the preferred size of a field.

The default value

As small as possible

Any size

Two times the expected size of the field's value

Normalization is used to ________________________.

		"Save the database design"
		"Include a common field in related tables"
		"Avoid data redundancy"
		"Enter sample data to test the design"

Answer 1

Question 1:
reasons for having a primary key are
A primary key identifies each record in the table.
Access responds faster to requests for specific records based on the primary key.
A primary key prevents duplicate values from being entered in the same field.
Answer:
All of the other answers are reasons for having a primary key.

Question 2:
The Entity Relationship Diagram is the name of the model used when designing databases.
Answer:
Entity Relationship Diagram

Question 3:
The default value is the preferred size of a field.
Answer:
The default value

Question 4:
Normalization is used to Avoid data redundancy.
Answer:
Avoid data redundancy