Test: Quiz: Normalization and First Normal Form

Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.

Normalization and First Normal Form
(Answer all questions in this section)

1. When data is stored in more than one place in a database, the database violates the rules of ___________. Mark for Review
(1) Points

Normalization (*)

Replication

Normalcy

Decency

2. When all attributes are single-valued, the database model is said to conform to: Mark for Review
(1) Points

1st Normal Form (*)

2nd Normal Form

3rd Normal Form

4th Normal Form

3. An entity can have repeated values and still be in 1st Normal Form. True or False? Mark for Review
(1) Points

True

False (*)

4. The following entity is on 1st normal form: True or False?
ENTITY: VEHICLE
ATTRIBUTES:
REGISTRATION
MAKE
MODEL
COLOR
DRIVER
PASSENGER 1
PASSENGER 2
PASSENGER 3

Mark for Review
(1) Points

True

False (*)