Question

What relationship pattern is illustrated in the following schema?

VEHICLE (VehicleID, Cost)
CAR (VehicleID, NumberOfSeats)
TRUCK (VehicleID, CargoCapacity)
VehicleID in CAR must exist in

VehicleID in VEHICLE VehicleID in TRUCK must exist in VehicleID in VEHICLE.

A) Association relationship
B) Intersection relationship
C) Recursive relationship
D) Strong entity relationship
E) Supertype/subtype relationship

Answer 1

E) Supertype/subtype relationship

Step-by-step explanation:

The type of relationship pattern illustrated in the schema below is E) Supertype/subtype relationship

Supertype/subtype relationship is the types of relationship that exist in the form of parent - children relationship in an entity. The supertype entity is the parent while the subtype entity is the child. The supertype entity contains one or more attributes that is common to the subtype entity.

The schema first define the Supertype entity:

VEHICLE (VehicleID, Cost)

CAR (VehicleID, NumberOfSeats)

TRUCK (VehicleID, CargoCapacity)

Then, the following (subtype entity) make reference to the Supertype:

VehicleID in CAR must exist in

VehicleID in VEHICLE

VehicleID in TRUCK must exist in

VehicleID in VEHICLE.

Since the subtype is making reference to supertype, we can say the relationship pattern illustrated in the schema is: Supertype/subtype relationship.