Given the following entities, which of the choices below would be the most complicated? Automobile: VIN, EngineSize, NumberOfDoors, NumberOfPassengers, FuelType, Transmission
SUV: VIN, EngineSize, NumberOfPassengers, NoWheelDrive, FuelType, Transmission
Truck: VIN, EngineSize, NoWheelDrive, FuelType, Transmission, Payload
A) Define one vehicle entity type to hold all entities.
B) Define a separate entity type for each entity.
C) Define a supertype called vehicle and make each of the entities subtypes.
D) Keep only the Truck entity type.

Question

Quizplus · Accepted Answer

Defining one vehicle entity type to hold all entities would be the most complicated because it would require accommodating all attributes of different vehicle types, leading to a complex and potentially inefficient design.

Given the Following Entities, Which of the Choices Below Would