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

Question

Quizplus · Accepted Answer

This schema illustrates a supertype/subtype relationship, where VEHICLE is the supertype entity that has common properties for all vehicles, and CAR and TRUCK are subtype entities that inherit the VehicleID key from VEHICLE and have additional attributes specific to each type.

What Relationship Pattern Is Illustrated in the Following Schema