1.Consider the following relational scheme. An employee can only work in one department at a time; they can work in another department after they have ended their contract in the current department. A department has only one manager, which is indicated by the Eid as managerid.

Employee(eid: integer, ename: string, age: integer, grade: integer, salary: real)

EmployeeArchives(eid: integer, ename: string, age: integer, grade: integer, salary: real)

Works(eid: integer, did: integer, start_date: date, end_date: date)

Department(did: integer, budget: real, managerid: integer)

Using the available information, use MySQL DDL to create a database from the relational schema above. Make sure to include integrity constraints such as domain, primary key, foreign key and mention your assumptions if needed.

2. Using the same schema from No. 1, write MySQL integrity constraints using CHECK constraints or MySQL Triggers to ensure each of the following requirements, considered independently Make sure to include the test query and its explanation for each constraint using MySQL DML/DDL.

a. Employees must get a minimum salary based on their grade: minimum salary for grade 1 is Rp1.000.000, for grade 2 is Rp2.000.000, and so on, until grade 10, which is Rp10.000.000. Also, note that the value of an employees grade is between 1 and 10.

b. Every employee is given a raise once every year based on their work duration (which is counted from the start date until now). If they have worked for >10 years, the raise is 20%; If they have worked for >5 years, the raise is 15%; If they have worked for >=1 years, the raise is 10%; If they have worked for <1 year, the raise is 5%.

c. A manager's salary must be more than an employees salary within the same department.

d.Whenever an employee is given a raise, the department's budget must be increased to be 10% greater than the sum of salaries of all employees in the department.

e.Whenever an employee is fired or resigned, their data should be deleted from the Employee relation and inserted in a relation named EmployeeArchives.