The Driver Relationship team realized that there is no need for DRIVER_DRIVING_LICENSE_CHECKED field in the active drivers table. Since all the drivers are already active in InstantRide, their driving licenses should be checked regularly. The team wanted you to remove the field from the table. Instructions Page 1 of 4Scenario 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_EMAIL3001JackHillj.hill@xmail.com3002RyanCollinsr.collins@xmail.com3003NursinYilmazn.atak@gmail.com3004SarahPrices.price@xmail.com3005BobbyGriffinb.griffin@xmail.com3006RandyClarkr.clark@xmail.com3007JoseThomasj.thomas@xmail.com3008NursinYilmazn.yilmaz@xmail.comUSERS TableIn the DRIVERS table, all the drivers in the InstantRide are stored with their name, drivinglicense number and check and rating information:DRIVER IDDRIVER_FIRST_NAME DRIVER_LAST_NAME DRIVER DRIVING_LICENSE_IDDRIVER START DATE DRIVER_DRIVING_LICENSE CHECKEDDRIVER_RATING2001WillieButler18745012019-09-124.42002JustinHoward19538532019-09-094.82003AnthonyWalker17354872019-09-1513.52004EceYilmaz17347472019-08-151DRIVERS TableIn the CARS table, all the cars in the InstantRide system are kept with the license plate, modeland year:CAR IDCAR PLATECAR_MODELCAR YEAR1001BB-542-ABTOYOTA PRIUS20181002BB-883-EETESLA MODEL 320191003BB-451-ZNTOYOTA AURIS20191004B-189-ММMERCEDES E2002019CARS Table Finally, 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:TRAVEL IDTRAVEL, END_TIMETRAVEL, START LOCATIONTRAVEL DISCOUNTTRAVEL_START_TIMETRAVEL END LOCATIONTRAVEL PRICEDRIVER IDCAR IDUSER ID50012019-10-01 04:04:559614 York Road84 Church Lane2019-10-01 04:14:1915.44200110033005NULL50022019-10-01 05:57:332019-10-01 06:12:3347 Church Street68 High Street20.56200110033006NULL50032019-10-01 13:35:202019-10-01 13:45:102 Windsor Road95 West Street12.32200210013002NULL50042019-10-02 08:44:482019-10-02 09:15:289060 Mill Lane27 Main Road30.492003100230010.1350052019-10-02 16:38:542019-10-02 16:48:102 Queensway24 Mill Lane11.15200110033007NULL50062019-10-03 19:12:142019-10-03 19:23:4550 Main Road93 Broadway14.612003100230070.1050072019-10-03 16:06:362019-10-03 16:08:5639 Park Road91 West Street4.412002100430030.1450082019-10-03 17:17:1237 The Drive17 Stanley Road25.1220010.252019-10-03 17:37:421003300150092019-10-03 21:16:482019-10-03 21:26:1877 Mill Road724 Springfield Road13.55200110033005NULL50102019-10-03 23:21:402019-10-03 23:39:1016 Church Road30 North Road25.622003100230030.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.

Structured Query Language : SQL is a space explicit language utilized in programming and intended…

Finally, the transactions of the rides are stored in the TRAVELS table. For each travel, start and end time with location are stored. In addition, the involved driver, car and user are listed for each drive. Price and discount information are also available in the database: TRAVEL ID TRAVEL, START_LOCATION TRAVEL, END_LOCATION DRIVER ID TRAVEL DISCOUNT TRAVEL_START_TIME TRAVEL END TIME TRAVEL PRICE CAR ID USER ID 5001 2019-10-01 04:04:55 2019-10-01 04:14:19 9614 York Road 84 Church Lane 15.44 2001 1003 3005 NULL 5002 2019-10-01 05:57:33 2019-10-01 06:12:33 47 Church Street 68 High Street 20.56 2001 1003 3006 NULL 5003 2019-10-01 13:35:20 2019-10-01 13:45:10 2 Windsor Road 95 West Street 12.32 2002 1001 3002 NULL 5004 2019-10-02 08:44:48 2019-10-02 09:15:28 9060 Mill Lane 27 Main Road 30.49 2003 1002 3001 0.13 5005 2019-10-02 16:38:54 2019-10-02 16:48:10 2 Queensway 24 Mill Lane 11.15 2001 1003 3007 NULL 5006 2019.10-03 19:12:14 2019-10-03 1923:45 50 Main Road 93 Broadway 14.61 2003 1002 3007 0.10 5007 2019-10-03 16:06:36 2019-10-03 16:08:56 39 Park Road 91 West Street 4.41 2002 1004 3003 0.14 5008 2019-10-03 17:17:12 2019-10-03 17:37:42 37 The Drive 17 Stanley Road 25.12 2001 1003 3001 0.25 5009 2019-10-03 21:16:48 2019-10-03 21:26:18 77 Mill Road 724 Springfield Road 13.55 2001 1003 3005 NULL 5010 2019-10-03 23:21:40 2019-10-03 23:39:10 16 Church Road 30 North Road 25.62 2003 1002 3003 0.20 TRAVELS Table You are assigned as the database administrator to collect and manage transactional data of the InstantRide operations. Your main task is to create SQL scripts to help other teams to retrieve the requested data. In the following activities, you will create the scripts, run against the database and send the result to the corresponding teams.

12th Edition

ISBN:9781305627482

Author:Carlos Coronel, Steven Morris

Publisher:Carlos Coronel, Steven Morris

Chapter2: Data Models

Section: Chapter Questions

Problem 10P