The Car Maintenance team also wants to store the actual maintenance operations in the database. The team wants to start with a table to store CAR_ID (CHAR(5)), MAINTENANCE_TYPE_ID (CHAR(5)) and MAINTENANCE_DUE (DATE) date for the operation. Create a new table named MAINTENANCES. The PRIMARY_KEY should be the combination of the three fields. The CAR_ID and MAINTENACNE_TYPE_ID should be foreign keys to their original tables. Cascade update and cascade delete the foreign keys. Scenario and Database Model: InstantRideInstantRide is the new ride sharing application in the city and it has just started its operations.With the help of the InstantRide mobile application, the users request a ride with their location.Drivers and cars are assigned to the request; and then the driver picks up the user to ride theirrequested location. Information for the users, drivers and cars are stored in the database aswell as the travel transactions.In the USERS table, information for the users are stored with their first name, last name andemail:USER IDUSER FIRST_NAMEUSER LAST NAMEUSER EMAIL3001JackHillJhillexmail.com3002RyanCollinsr.collins@xmail.com3003NursinYilmazn.atak@gmail.com3004SarahPrices.price@xmail.com3005BobbyGriffinbgriffinexmal.com3006RandyClarkr.clark@xmail.com3007JoseThomasjthomas@xmail.com3008NursinYilmaznyilmazexmail.comUSERS TableIn the DRIVERS table, all the drivers in the InstantRide are stored with their name, drivinglicense number and check and rating information:DRIVER ID DRIVER FIRST NAME DRIVER LAST NAME DRIVER DRIVING LICENSE ID DRIVER START DATE DRIVER DRIVING LICENSE CHECKED DRIVER RATING2001willieButler18745012019-09-124.42002JustinHoward19538532019-09-094.82003AnthonyWalker17354872019-09-153.52004EceYilmaz17347472019-08-15DRIVERS Table In the CARS table, all the cars in the InstantRide system are kept with the license plate, modeland year:CAR MODELCAR IDCAR PLATECAR YEAR1001BB-542-ABΤOYOTA PRIUS20181002BB-883-EETESLA MODEL 320191003BB-451-ZNΤΟΥOTA AURIS20191004BB-189-MMMERCEDES E2002019CARS TableFinally, the transactions of the rides are stored in the TRAVELS table. For each travel, start andend time with location are stored. In addition, the involved driver, car and user are listed foreach drive. Price and discount information are also available in the database:TRAVELDTRAVEL START TIMETRAVEL END TIMeTRAVEL START LOCATIONTRAVEL END LOCATIONTRAVEL PRICEDRIVER IDCARDUSER DTRAVEL DISCOUNT2010.10ar aeteA Ver teadChuren Lane200147 Churen seetgh eet20.2001scosNULL2011a 13::toWineear ear20201-104 a1:s20so MI Lane77 Mn tea201 16RR20114 16:R:1011.15100200-0 1121420131001 11:21etso Mn natnreanwy200n500720160 16062019-1003 1605630 a Anod91 West or4.41200201s10-03 1717122019-10-03 17:374237 The Drive17 Staey oed25.122001100330010.2550092016-0216201910-03 2126:1877 M oad724 Sprngie Rad135520011003NULL5010201510-03 23214020191003 2331016 Church ead30 North Road2542200930030.20TRAVELS TableYou are assigned as the database administrator to collect and manage transactional data of theInstantRide operations. Your main task is to create SQL scripts to help other teams to retrievethe requested data. In the following activities, you will create the scripts, run against thedatabase and send the result to the corresponding teams.

Question

The Car Maintenance team also wants to store the actual maintenance operations in the database. The team wants to start with a table to store CAR_ID (CHAR(5)), MAINTENANCE_TYPE_ID (CHAR(5)) and MAINTENANCE_DUE (DATE) date for the operation. Create a new table named MAINTENANCES. The PRIMARY_KEY should be the combination of the three fields. The CAR_ID and MAINTENACNE_TYPE_ID should be foreign keys to their original tables. Cascade update and cascade delete the foreign keys. Scenario and Database Model: InstantRideInstantRide is the new ride sharing application in the city and it has just started its operations.With the help of the InstantRide mobile application, the users request a ride with their location.Drivers and cars are assigned to the request; and then the driver picks up the user to ride theirrequested location. Information for the users, drivers and cars are stored in the database aswell as the travel transactions.In the USERS table, information for the users are stored with their first name, last name andemail:USER IDUSER FIRST_NAMEUSER LAST NAMEUSER EMAIL3001JackHillJhillexmail.com3002RyanCollinsr.collins@xmail.com3003NursinYilmazn.atak@gmail.com3004SarahPrices.price@xmail.com3005BobbyGriffinbgriffinexmal.com3006RandyClarkr.clark@xmail.com3007JoseThomasjthomas@xmail.com3008NursinYilmaznyilmazexmail.comUSERS TableIn the DRIVERS table, all the drivers in the InstantRide are stored with their name, drivinglicense number and check and rating information:DRIVER ID DRIVER FIRST NAME DRIVER LAST NAME DRIVER DRIVING LICENSE ID DRIVER START DATE DRIVER DRIVING LICENSE CHECKED DRIVER RATING2001willieButler18745012019-09-124.42002JustinHoward19538532019-09-094.82003AnthonyWalker17354872019-09-153.52004EceYilmaz17347472019-08-15DRIVERS Table In the CARS table, all the cars in the InstantRide system are kept with the license plate, modeland year:CAR MODELCAR IDCAR PLATECAR YEAR1001BB-542-ABΤOYOTA PRIUS20181002BB-883-EETESLA MODEL 320191003BB-451-ZNΤΟΥOTA AURIS20191004BB-189-MMMERCEDES E2002019CARS TableFinally, the transactions of the rides are stored in the TRAVELS table. For each travel, start andend time with location are stored. In addition, the involved driver, car and user are listed foreach drive. Price and discount information are also available in the database:TRAVELDTRAVEL START TIMETRAVEL END TIMeTRAVEL START LOCATIONTRAVEL END LOCATIONTRAVEL PRICEDRIVER IDCARDUSER DTRAVEL DISCOUNT2010.10ar aeteA Ver teadChuren Lane200147 Churen seetgh eet20.2001scosNULL2011a 13::toWineear ear20201-104 a1:s20so MI Lane77 Mn tea201 16RR20114 16:R:1011.15100200-0 1121420131001 11:21etso Mn natnreanwy200n500720160 16062019-1003 1605630 a Anod91 West or4.41200201s10-03 1717122019-10-03 17:374237 The Drive17 Staey oed25.122001100330010.2550092016-0216201910-03 2126:1877 M oad724 Sprngie Rad135520011003NULL5010201510-03 23214020191003 2331016 Church ead30 North Road2542200930030.20TRAVELS TableYou are assigned as the database administrator to collect and manage transactional data of theInstantRide operations. Your main task is to create SQL scripts to help other teams to retrievethe requested data. In the following activities, you will create the scripts, run against thedatabase and send the result to the corresponding teams.

Accepted Answer

DELETE CASCADE: -
When we constitute a foreign key using this option, it deletes the referencing…