In this part you will be to map the EER schema design to a relational database schema, and create the tables corresponding to the relational schema using the MYSQL. You will add to your report a...

Please read the description carefully and look at the EER diagram that's provided below to answer this part.

Extracted text: In this part you will be to map the EER schema design to a relational database schema, and create the tables corresponding to the relational schema using the MYSQL. You will add to your report a listing of the CREATE TABLE statements. Specify as many constraints (key, referential integrity) as you can in the relational schema. You should state the choices you made during the EER-to-relational mapping, and the reasons for your choices.


Extracted text: CategoryType Model Phone VehiclelD IdNo Name Year CAR CUSTOMER DailyRate 1 WeeklyRate INVOLVED RentallD M (Current_Or_Scheduled) M RENTS RENTAL RentalType AmountDue RentalType d RentallD "W" RentallD WEEKLY DAILY RENTAL NoOfWeeks NoOfDays StartDate ReturnDate StartDate ReturnDate