QUESTION $4$

Write the data manipulation statements of SQL that modify the contents of a database listed on page $4$ of the

examination paper in the ways described below. Note, that you are not allowed to modify and$/$or to drop any

consistency constraints. Also note, that to implement some of the modifications listed below you may need

more than one data manipulation statement of SQL$.$

$(1)$ Insert into the database information about a new project. The project number is $1010,$ title is Puzzle, the

sponsor is ABC Ltd$,$ done by the department number $5,$ and budget is $$180000\mathrm{.}00.$

Two employees work on the new project. Employee $00107$ has been assigned to the project. She

spends $15$ hours on the new project. Employee $00187$ project has been changed to this new one. He

spends $30$ hours on the new project.

$(2)$ The project $1005$ has been cancelled. Remove the related data from the database.

$(3)$ An employee $00187($neither a manager nor a supervisor$)$ decided to quit a job. Remove all information

about the employee from the database.

$(4)$ An employee $00110$ starts to work in the department ACCOUNTING as a manager at $01/09/2018.$ An

employee $00120$ starts to work in the department SALES as a manager at the same day.

Note: The employees supervised by their department managers should also be updated.