1. Consider the following relation schemas: Department (dnumber, dname, employee count), PK: dnumber. Employee (eid. fname. Iname, salary, dno), PK: eid. FK: dno refs Department. Write triggers in PL/SQL that satisfy the following requirements: The employee count column in the Department table records the current number of employees in each department. You should guarantee that, whenever an employed record is inserted, deleted or updated in the Employee table, the employee count attribute always has the correct value for the affected department(s) in the Departme table. Also, no department in the organization should have an average salary lower than 10,000. When the insertion, deletion or update of an employee record causes the

Structured Query Language is the full form of SQL. It is one of the standard languages to deal with the relational database. It is used to insert, update, delete, and search the records stored in a RDBMS. The relational databases are created and managed …