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.Create a new table to store car maintenance types. Scenario and Database Model: Instant RideInstantRide is the new ride sharing application in the city and it has just started its operations.With the help of the Instant Ride 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 Table20022003USER_FIRST_NAME2004JackRyanNursinSarahBobbyRandyJoseDRIVERS TableNursinButlerHowardWalkerYilmazUSER_LAST_NAMEIn the DRIVERS table, all the drivers in the Instant Ride are stored with their name, driving licensenumber and check and rating information:1735487HillDRIVER ID DRIVER FIRST NAME DRIVER LAST NAME DRIVER DRIVING LICENSE ID DRIVER START DATE DRIVER DRIVING LICENSE CHECKED DRIVER RATING2001Willie18745012019-09-124.4Justin19538532019-09-09AnthonyEce1734747CollinsYilmazPriceGriffinClarkThomasYilmaz2019-09-152019-08-15USER_EMAILj.hill@xmail.comr.collins@xmail.comn.atak@gmail.coms.price@xmail.comb.griffin@xmail.comr.clark@xmail.comj.thomas@xmail.comn.yilmaz@xmail.com114.83.50 In the CARS table, all the cars in the InstantRide system are kept with the license plate, modeland year:CAR ID1001100210031004CARS TableTRAVEL ID500150025003501550065007500850095010TRAVEL START TIME2016-10-01 00:04:552015-10-01 05:57:352015-10-01 13:36:202015-10-02 042015-10-02 12015-10-03 19:12:142015-10-03 16:06:362015-10-03 17:17:122015-10-05 21:16:482015-10-03 23:21:40CAR PLATETRAVELS TableBB-542-ABBB-883-FEBB-451-ZNBB-189-MMFinally, 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:TRAVEL END TIME2019-13.41 04:14:192015-10-01 06:12:352019-10-01 13:45:102013-13-4791:15:282019-10-43 16:102015-10-01 13:21:152019-10-03 16:38:562019-10-03 17:37:422019-10-03 21:26:182019-10-03 23:39:10TRAVEL START LOCATION0514York Road47 Church Street>Wea3050 MillaneCAR MODEL50 Main Road39 Pa Road37 The Drive77 Mill Road16 Church RoadTOYOTA PRIUSTESLA MODEL 3TOYOTA AURISMERCEDES E200TRAVEL END LOCATION58 High Street95 W77 Man24M1091 West S17 Stanley Road725 Springfield Road30 North RoadTRAVEL PRICE15.4420.5613.3210.4914,814.4125.1213.5525.62CAR YEAR20182019201920192002200120012003DRIVER ID CAR ID20012001200720052001200510081002100410031002USER ID1006300630023007100730013003TRAVEL DISCOUNTNULLNULLMEL0.100.140.25MAL0.20You 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 retrieve therequested data. In the following activities, you will create the scripts, run against the database andsend the result to the corresponding teams.

Hello student I am going to explain you about this question in next step

Answered: The InstantRide Management team founded…

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE