Section 6
(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?

  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

(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?

True

  False