The Driver Relationship team wants to ensure that the all driving license IDs in the active drivers table have the length of 7. Alter the ACTIVE_DRIVERS table created in Chapter 8, Activity 1 to check the length of the DRIVER_DRIVING_LICENSE_ID. 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.

The CHECK constraint is used to limit the value range that can be placed in a column. Syntax: ALTER TABLE table_name ADD CONSTRAINT constraint_name CHECK (column_name condition);Required Query: ALTER TABLE ACTIVE_DRIVERS ADD CONSTRAINT driver_licence_length CHECK (Length(DRIVER_DRIVING_LICENCE_ID) =7);