Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

Hello, These are SQL questions from MindTap

image text in transcribedimage text in transcribed
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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Business Research Methods

Authors: Emma Bell, Bill Harley, Alan Bryman

5th Edition

0198809875, 9780198809876

More Books

Students also viewed these General Management questions

Question

How do sex and gender differ?

Answered: 1 week ago

Question

5. Give examples of binary thinking.

Answered: 1 week ago