Question

Examine the following Entity and decide which sets of attributes break the 3rd Normal Form rule:ENTITY: TRAINATTRIBUTES:TRAIN IDMAKEDRIVER IDDRIVER NAMEDATE OF MANUFACTUREMark for Review(1) PointsTRAIN ID, MAKEDRIVER ID, DRIVER NAME (*)MAKE, DATE OF MANUFACTURENone of the above, the entity is already in 3rd Normal Form.

Answer 1

The attribute set "TRAIN ID, MAKEDRIVER ID, DRIVER NAME" breaks the 3rd Normal Form rule.

This is because the attribute set "DRIVER NAME" is dependent on only part of the primary key, "DRIVER ID". In other words, if there are multiple drivers with the same ID working on different trains, their names would be repeated in every record for that train.

To adhere to 3NF, the attribute "DRIVER NAME" should be moved to a separate entity with its own primary key, and a foreign key referencing the driver ID should be added to the TRAIN entity.

Step-by-step explanation:

This is my view. hope it helps