Question: Hello, These are SQL questions from MindTap Instructions Page 4 of 4 Task 5: The Driver Relationship team realized that there is no need for

Hello, These are SQL questions from MindTap


Instructions Page 4 of 4 Task 5: The Driver Relationship team realized that there is no need for DRIVER_DRIVING_LICENSE_CHECKED eld in the active drivers table. Since all the drivers are already active in lnstantRide, their driving licenses should be checked regularly. The team wanted you to remove the eld from the table. Task CI Removethe DRIVER_DRIVING_LICENSE_CHECKED eld > from the ACTIVE_DRIVERS table. Task 6: The Car Maintenance team wants to update the price of Oil Change to 75. In addition, they will no longer provide or require a Gas Pump Change in the future and there is no need to keep the maintenance item in the database. Update the cost of the oil change and remove the gas pump change option from the MAINTENANCEJYPES table. Task D Update the maintenance type information > | Instructions Page 3 of 4 Task 3: The Car Maintenance team wants to insert and store the following maintenance types to the MAINTENANCEJYPES table: 0 ID11' w Description :Tire Change; Price :50 0 ID :2\" Description :0\" Change; Price :45 w 0 ID :3\" Description ;Full Cleaning; Price :100 - 0 ID :4\" Description :Gas Pump Change; Price :145 w Task D Add the four maintenance types to the > MAINTENANCEJYPES table. Task 4: The Car Maintenance team wants to add new maintenance tasks into the system. The team has determined that there should be Tire Change (ID: 1) task for every car with the model year 2018 in lnstantRide. Due date of this maintenance tasks is 31 December, 2020. Insert the rows into the MAINTENANCES table for every car built in 2018 and send the data back to the team. Task
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
