b$)$ Consider following EER diagram for a car dealer database. Map this diagram into a relational schema and

specify all the primary & foreign keys. For the VEHICLE to CAR$/$TRUCK$/$SUV specialization, pick one of the

options discussed in class $(8$A$,8$B$,8$C$,8$D$).$ Justify your choice.

Describe each step of the mapping process. For example:

Step $1-$ mapping regular entities: VEHICLE, SALESPERSON, CUSTOMER.

$-$ Regular entity type VEHICLE is mapped as a VEHICLE relation. All simple attributes are included.

Attribute $$Vin$$ is chosen as a primary key $...$

$...$

Step $7$ mapping n$-$ary relationships: SALE $...$

Step $8$ mapping specializations and generalizations: CAR, TRUCK, SUV $...$