$1-$ Create the following tables and insert your own values: $(10$

Marks$)$

$-$Employee $($emp$\_$ID$,$ Name, Birth$\_$Date, Title, Salary, Department$\_$No$)$

Project $($Project$\_$No$,$ Project$\_$Name, Budget, Department$\_$No$)$

Department $($Department$\_$No$,$ d Department$\_$name$)$

$-$Working$\_$Project $($emp$\_$ID$,$ Project$\_$No$,$ hours$)$

Finished$\_$Project$($emp$\_$ID$,$ Project$\_$No$,$ Finished$\_$hours, comments$)$

$2-$ Write queries using database triggers for the following $(20$ Marks each$)$

a$.$ Write Database Triggers if a success value insert message shows $"$ Record Insert $$:

i$.$ Write query to insert values in Employee table.

ii$.$ Write query to insert values in Department table.

b$.$ Create a trigger if the budget more than $50,000$ a message appears $($The Budget is over $).$

c$.$ Write Databse Triggers for any delete value message shows $"$ Delete Done".

i$.$ Write query to delete a value from Working Project Table

ii$.$ Write query to delete a value from Project Table.

d$.$ Write Database Triggers for all Working$\_$Project.hours are more than $24$ hours, message shows $"$ Project Exceed KPI $"$

i$.$ Write a query to insert in Working$\_$Project table values that hours

ii$.$ Write a query to insert in Working$\_$Project table values that hours $>24.$