Consider the EER diagram in Figure for a car dealer

Map the EER schema into a set of relations. For the VEHICLE to CARITRUCK/SUV generalization consider the four options presented in Section and show the relational schema design under each of those options.
Option 8A: Multiple relations-super-class and subclasses.
Option 8B: Multiple relations-subclass relations only.
Option 8C: Single relation with one type attribute.
Option 8D: Single relation with multiple types attributes.

Transcribed Image Text:

Figure EER diagram for a car dealer. CAR Engine size VinPrice VEHICLEd Model N Date SUV No seats SALE SALESPERSON CUSTOMER Address City Street Name Ssn Name State