Test: Quiz: Third Normal Form

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

Third Normal Form
(Answer all questions in this section)

1. As a database designer it is your job to store data in only one place and the best place. True or False? Mark for Review
(1) Points

True (*)

False

2. Examine the following Entity and decide which sets of attributes breaks the 3rd Normal Form rule: (Choose Two)
ENTITY: TRAIN (SYNONYM: ROLLING STOCK)
ATTRIBUTES:
TRAIN ID
MAKE
MODEL
DRIVER NAME
DEPARTURE STATION
NUMBER OF CARRIAGES
NUMBER OF SEATS
DATE OF MANUFACTURE

Mark for Review
(1) Points

(Choose all correct answers)

TRAIN ID, MAKE

DEPARTURE STATION, DRIVER NAME (*)

NUMBER OF CARRIAGES, NUMBER OF SEATS (*)

MODEL, DATE OF MANUFACTURE



3. No databases in the world is ever truly on 3rd Normal Form. Everyone always stops after 2nd Normal Form. True or False? Mark for Review
(1) Points

True

False (*)