Please show all work and write it in PL/SQL and copypaste what you have. 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 ofemployees in each department. You should guarantee that, whenever an employeerecord is inserted, deleted or updated in the Employee table, the employee countattribute always has the correct value for the affected department(s) in the Departmenttable.Also, no department in the organization should have an average salary lower than10,000. When the insertion, deletion or update of an employee record causes theaverage salary of a department to be lower than 10,000, the corresponding operationshould be cancelled.You may create additional tables or views if needed.

Dear Student, The answer to your question is given below -

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

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

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

What is Stored Procedure (SP) in sql?
What is the purpose of the SQL isolation levels?
what is the difference between inner and outer join in sql?
write a PL/SQL procedure to find the Maximum of the two values
how to delete department id in pl/sql from department id - 60 otherwise raise an exception
Q. Which Data type is used in sql for assiging guid value?
What is the purpose of the COMMIT command in SQL?
What are the Advantages of SQL-invoked routines.
SQL homework Please help me with this homework
How to Grant access privileges on objects created in the future in sql.
In what scenarios is the CAST function preferred over CONVERT in SQL for type conversion?
What potential problems might arise when using non-deterministic functions in SQL?