(Answered): 2. Consider the EER diagram in Figure 9.9 for a car dealer. (50) Map the EER schema into a set of r ...

2. Consider the EER diagram in Figure 9.9 for a car dealer. (50) Map the EER schema into a set of relations. For the VEHICLE to CAR/TRUCK/SUV generalization, consider the four options presented in Section 9.2.1 and show the relational schema design under each of these options. CAR Engine_size Vin Price VEHICLE d TRUCK Tonnage Model N Date SUV No_seats SALE 1 SALESPERSON CUSTOMER Address City Sid Street Name Ssn Name State Figure 9.9 EER diagram for a car dealer.