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 their requested location. Information for the users, drivers and cars are stored in the database as well as the travel transactions.I need help with task 4 and task 5. Module 8 Activity 1Instructions Page 4 of 4Task2.sql | Task3.sql| Task4.sql+Task1.sqlTask5.sqlTask6.sql1 ALTER TABLE ACTIVE_DRIVERS2 ADD CONTRAINT DuplicateCheck (DRIVER_FIRST_NAME, DRIVER_LAST_NAMEDRIVER_DRIVING_LICENSE_ID);Task 5:3The Driver Relationship team requested to ensure that</>there will be no duplicates in the active drivers tables interms of first name, last name and driving license ID. Youneed to create a constraint in the ACTIVE_DRIVERStable, called DuplicateCheck, to ensure the first name,last name, and the driving license ID are unique.TaskCreate a constraint on the ACTIVE_DRIVERS9 SQL Viewer+tableTask 6:ERROR 1064 (42000) at line 1: You have an error in your SQL syntax;check the manual that corresponds to your MYSQL server version for theright syntax to use near 'DuplicateCheck (DRIVER_FIRST_NAME,DRIVER LAST_NAME, DRIVER DRIVING_LICENSE_ID)' at line 2The Car Maintenance team considered that the availablemaintenance tasks should also have the price informationin the database. Alter the MAINTENANCE_TYPES table toinclude a new column named MALINTENANCE PRICE of4/4InstantRide Module 8 Activity 1Instructions Page 3 of 4Task1.sqlTask2.sqlTask3.sqlTask4.sqlTask5.sqlTask6.sql1 CREATE INDEX NameSearchTask 4:2 ON ACTIVE_DRIVERS (DRIVER_FIRST_NAME, DRIVER_LAST_NAME, DRIVER_DRIVING_LICENSE_ID);|The Driver Relationship team wants to have quick search options for theactive drivers. The team specifically mentioned that they are using first</>name, last name and driving license ID to search the drivers. Create anindex called NameSearch on the ACTIVE_DRIVERS table created in task3.TaskCreate an INDEX to search for driver information.0.00out of10.00SQL ViewerO out of 1 checks passed. Review the results below for moredetails.ChecksQuery completedSQL Database Test • IncompleteCreate an INDEX to search the ACTIVE_DRIVERS table3/4<>InstantRide

Hey your task 4 query is correct as per provided in the pictures that you have solved.

Answered: Scenario and Database Model:…

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Scenario and Database Model: InstantRide

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 their requested location. Information for the users, drivers and cars are stored in the database as well as the travel transactions.

I need help with task 4 and task 5.