Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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. TaskStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started