The InstantRide Management team founded a new team for car maintenance. The new team is responsible for the small maintenance operations for the cars in the InstantRide system. The main idea is to take actions faster and minimize the time spent for the maintenance. Therefore, the Car Maintenance team wants to store MAINTENANCE_TYPE_ID (char(5)) and a MAINTENANCE_TYPE_DESCRIPTION (varchar(30)) in the database. Using MAINTENANCE_TYPE_ID as the PRIMARY KEY, create a new table, MAINTENANCE_TYPES, and send the table description with the column names and types to the Car Maintenance team. In the CARS table, all the cars in the InstantRide system are kept with the license plate, modeland year:CAR_ID1001100210031004CARS TableTRAVEL ID5001500250035004500550065007500850095010TRAVEL_START_TIME2019-10-01 04:04:552019-10-01 05:57:332019-10-01 13:35:202019-10-02 08:44:48Finally, 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 for eachdrive. Price and discount information are also available in the database:2019-10-02 16:38:542019-10-03 19:12:142019-10-03 16:06:362019-10-03 17:17:122019-10-03 21:16:482019-10-03 23:21:40CAR_PLATETRAVELS TableBB-542-ABBB-883-EEBB-451-ZNBB-189-MMTRAVEL_END_TIME2019-10-01 04:14:192019-10-01 06:12:332019-10-01 13:45:102019-10-02 09:15:282019-10-02 16:48:102019-10-03 19:23:452019-10-03 16:08:562019-10-03 17:37:422019-10-03 21:26:182019-10-03 23:39:10TRAVEL_START_LOCATION9614 York Road47 Church Street2 Windsor Road9060 Mill Lane2 Queensway50 Main Road39 Park Road37 The Drive77 Mill RoadCAR_MODEL16 Church RoadTOYOTA PRIUSTESLA MODEL 3TOYOTA AURISMERCEDES E200TRAVEL_END_LOCATION84 Church Lane68 High Street95 West Street27 Main Road24 Mill Lane93 Broadway91 West Street17 Stanley Road724 Springfield Road30 North RoadTRAVEL PRICE15.4420.5612.3230.4911.1514.614.4125.1213.5525.62DRIVER ID200120012002200320012003200220012001CAR_YEAR20032018201920192019CAR ID1003100310011002100310021004100310031002USER_ID3005300630023001300730073003300130053003TRAVEL_DISCOUNTNULLNULLNULL0.13NULL0.100.140.25NULL0.20 InstantRide 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 as well asthe travel transactions.In the USERS table, information for the users are stored with their first name, last name and email:USER_ID30013002300330043005300630073008USERS Table2001200220032004WillieUSER_FIRST_NAMEJustinAnthonyJackRyanEceNursinSarahBobbyRandyJoseNursinButlerHowardWalkerYilmazIn the DRIVERS table, all the drivers in the Instant Ride are stored with their name, driving licensenumber and check and rating information:1874501DRIVER_ID DRIVER_FIRST_NAME DRIVER_LAST_NAME DRIVER_DRIVING LICENSE_ID DRIVER_START_DATE DRIVER_DRIVING LICENSE_CHECKED DRIVER_RATING1953853USER_LAST_NAME1735487Hill1734747CollinsYilmazPriceGriffinClarkThomasYilmaz2019-09-122019-09-092019-09-152019-08-1511USER_EMAIL1j.hill@xmail.com1r.collins@xmail.comn.atak@gmail.coms.price@xmail.comb.griffin@xmail.comr.clark@xmail.comj.thomas@xmail.comn.yilmaz@xmail.com4.44.83.50

Question

The InstantRide Management team founded a new team for car maintenance. The new team is responsible for the small maintenance operations for the cars in the InstantRide system. The main idea is to take actions faster and minimize the time spent for the maintenance. Therefore, the Car Maintenance team wants to store MAINTENANCE_TYPE_ID (char(5)) and a MAINTENANCE_TYPE_DESCRIPTION (varchar(30)) in the database. Using MAINTENANCE_TYPE_ID as the PRIMARY KEY, create a new table, MAINTENANCE_TYPES, and send the table description with the column names and types to the Car Maintenance team. In the CARS table, all the cars in the InstantRide system are kept with the license plate, modeland year:CAR_ID1001100210031004CARS TableTRAVEL ID5001500250035004500550065007500850095010TRAVEL_START_TIME2019-10-01 04:04:552019-10-01 05:57:332019-10-01 13:35:202019-10-02 08:44:48Finally, 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 for eachdrive. Price and discount information are also available in the database:2019-10-02 16:38:542019-10-03 19:12:142019-10-03 16:06:362019-10-03 17:17:122019-10-03 21:16:482019-10-03 23:21:40CAR_PLATETRAVELS TableBB-542-ABBB-883-EEBB-451-ZNBB-189-MMTRAVEL_END_TIME2019-10-01 04:14:192019-10-01 06:12:332019-10-01 13:45:102019-10-02 09:15:282019-10-02 16:48:102019-10-03 19:23:452019-10-03 16:08:562019-10-03 17:37:422019-10-03 21:26:182019-10-03 23:39:10TRAVEL_START_LOCATION9614 York Road47 Church Street2 Windsor Road9060 Mill Lane2 Queensway50 Main Road39 Park Road37 The Drive77 Mill RoadCAR_MODEL16 Church RoadTOYOTA PRIUSTESLA MODEL 3TOYOTA AURISMERCEDES E200TRAVEL_END_LOCATION84 Church Lane68 High Street95 West Street27 Main Road24 Mill Lane93 Broadway91 West Street17 Stanley Road724 Springfield Road30 North RoadTRAVEL PRICE15.4420.5612.3230.4911.1514.614.4125.1213.5525.62DRIVER ID200120012002200320012003200220012001CAR_YEAR20032018201920192019CAR ID1003100310011002100310021004100310031002USER_ID3005300630023001300730073003300130053003TRAVEL_DISCOUNTNULLNULLNULL0.13NULL0.100.140.25NULL0.20 InstantRide 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 as well asthe travel transactions.In the USERS table, information for the users are stored with their first name, last name and email:USER_ID30013002300330043005300630073008USERS Table2001200220032004WillieUSER_FIRST_NAMEJustinAnthonyJackRyanEceNursinSarahBobbyRandyJoseNursinButlerHowardWalkerYilmazIn the DRIVERS table, all the drivers in the Instant Ride are stored with their name, driving licensenumber and check and rating information:1874501DRIVER_ID DRIVER_FIRST_NAME DRIVER_LAST_NAME DRIVER_DRIVING LICENSE_ID DRIVER_START_DATE DRIVER_DRIVING LICENSE_CHECKED DRIVER_RATING1953853USER_LAST_NAME1735487Hill1734747CollinsYilmazPriceGriffinClarkThomasYilmaz2019-09-122019-09-092019-09-152019-08-1511USER_EMAIL1j.hill@xmail.com1r.collins@xmail.comn.atak@gmail.coms.price@xmail.comb.griffin@xmail.comr.clark@xmail.comj.thomas@xmail.comn.yilmaz@xmail.com4.44.83.50

Accepted Answer

CREATE TABLE MAINTENANCE_TYPES(MAINTENANCE_TYPE_ID char(5) PRIMARY KEY, MAINTENANCE_TYPE_DESCRIPTION…