The Car Maintenance team wants to add Tire Change $($ID: $1)$ maintenance task for all cars with the due date of $1$ September, $2021.$ However, the team also wants to know that if an error occurs the updates will rollback to their previous state. Create a script for them to first add all tasks and then rollback the changes.

Task $2$

The Car Maintenance team wants to add Tire Change $($ID: $1)$ maintenance task for all cars with the due date of $1$ September, $2021.$ However, the team also wants to know that if an error occurs the updates will rollback to their previous state. Create a script for them to first add all tasks and then rollback the changes.

Task $5$

The Driver Relationship team wants to update the driving license id of an active driver:

Driver ID: $2003,$ New Driving License ID: $1735488$

In addition, the team wants to do the update over the ACTIVE$\_$DRIVERS VIEW and also want to see the actual change in the DRIVERS table.

Task $6$

The Driver Relationship team realized that maintaining driver IDs is difficult and requested an automatic way of incrementing the value when a new driver is added. You need to make the changes on the table to automatically increment the DRIVER$\_$ID$.$ After the change, you need to insert the following driver:

First Name: Nursin

Last Name: Yilmaz

Driving License ID: $4141447$

Start Date: $2021-12-28$

Driving License Checked: True

Rating: $4\mathrm{.}0$