Consider the instructor relation, as depicted in Figure A$\mathrm{.}5$ on page $1293,$ as well as thedepartment relation, as depicted in Figure A$\mathrm{.}3$ of page $1292$ in Database System Concepts, $7$thEdition, $2020,$ Avis Silberschatz, Henry F$.$ Korth, S$.$ Sudarshan.a$.$ All instructors who do not work in the Taylor building are going be given a $5\%$ raise $(4$marks$).$ Hint: be careful to not accidentally delete all the instructors in the Taylor building.Also make sure that your schema is correct before you do the assignment.b$.$ All instructors who work in the Taylor building are going to be given a raise. If they currentlymake less than or equal to $$75,000,$ they will be given a $10\%$ raise. If they make more than$$75,000$ they will be given a $5\%$ raise $(5$ marks$).$ Hint: be careful not to give any instructor adouble raise, as well as not to delete any of the instructors that do not teach in the Taylorbuilding. Also make sure that your schema is correct before you do the assignment.