Quiz 6

1) Database design can be looked at as a _____ process.

Three-step
Two-step
Four-step
Five-step

2) A phone number is an example of a(n) ______
Relationship
Property
Attribute
Entity
3) A(n) _____ is a link between tables.

Relationship
Field
Line
Property

4) The ____ in a table dictates what data can be stored in a field.

Field name
Field properties
Data type
Description

5) Data can be entered into a database using one of two methods: entering the data directly into the table or entering it in ________

A form
A query
A report
The relationship window

6) In a database, a(n) ____ is a field that uniquely identifies a record

Input mask
Named range
Yes/No field
Primary key

7) In a customer table, a(n) _____ field would serve as a good primary key

Date of birth
Customer ID
Address
Phone number

8) An appropriate example of the type of data that could be stored in a Short Text data type field is ________
Quantity
Salary
Name and Address
Customer ID

9) When two fields are needed to uniquely identify a record, a ____ key is used.

Composite
Foreign
Natural
Numeric

10) When a database is ______, redundancy is minimized.

Joined
Normalized
Shared
Delimited