$1.$ Create the database as shown.

$2.$ Add four people to the person table

$($example:

insert into person $($name$,$lastname$)$ values

$(\text{'}$name$1\text{'},$'lastname$1\text{'}),$

$(\text{'}$name$2\text{'},$'lastname$2\text{'}),$

$(\text{'}$name$3\text{'},$'lastname$3\text{'}),$

$(\text{'}$name$4\text{'},$'lastname$4\text{'})$;

$)$

$3.$ Add two sets of data to the salary table, one historical and the other current

$($example:

insert into salary $([$value$],[$date$],$id$\_$person$)$ values

$(1000,\text{'}2020-02-03\text{'},1),$

$(1000,\text{'}2020-02-03\text{'},2),$

$(1000,\text{'}2020-02-03\text{'},3),$

$(1000,\text{'}2020-02-03\text{'},4),$

$(1100,\text{'}2021-02-03\text{'},1),$

$(1200,\text{'}2021-02-03\text{'},2),$

$(1300,\text{'}2021-02-03\text{'},3),$

$(1400,\text{'}2021-02-03\text{'},4)$

;

$)$

$4.$ Write a trigger for table payout$\_$date$\_$month that automatically adds data to the

value and date fields, the trigger is to be runs after adding values into id$\_$person

and month. Trigger retrieves data from the salary table.

$($example:

insert into payout$\_$date$\_$month $($id$\_$person,$[$month$])$ values $(3,12)$

$)$

$5.$ Add another set of data, check if everything is working correctly.

Save the results as scripts on the Platon Solu