subject

Consider the following relation schemas: Department (dnumber, dname, employee_count), PK: dnumber. Employee (eid, fname, lname, 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 employee 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 Department 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 average salary of a department to be lower than 10,000, the corresponding operation should be cancelled. You may create additional tables or views if needed. Note that your triggers will be graded based on both correctness and efficiency.

ansver
Answers: 3

Other questions on the subject: Computers and Technology

image
Computers and Technology, 22.06.2019 02:50, brianna4455
Which of the following had the greatest influence on opening the internet to the generly public
Answers: 1
image
Computers and Technology, 22.06.2019 13:30, morganwendel126
Use the keyword strategy to remember the meaning of the following word. the meaning for the word has been provided. write your keyword and describe the picture you would create in your mind. centurion: a commander in the army of ancient rome. keyword: picture:
Answers: 2
image
Computers and Technology, 23.06.2019 16:50, lukeakalucas
15: 28read the summary of "an indian's view of indian affairs."15 betterin "an indian's view of indian affairs," it is asserted that conflicts could be reduced if white americansunderstood native americans..pswhich of the following would make this summary more complete? eleo the fact that chief joseph believes the great spirit sees everythinthe fact that chief joseph was born in oregon and is thirty-eight years oldo the fact that chief joseph states that he speaks from the hearthehehethe fact that chief joseph of the nez percé tribe made this claimebell- ==feetle===-felsefe ==submitmark this and retum.=
Answers: 3
image
Computers and Technology, 23.06.2019 18:50, annieleblanc2004
Ais a picture icon that is a direct link to a file or folder
Answers: 1
You know the right answer?
Consider the following relation schemas: Department (dnumber, dname, employee_count), PK: dnumber. E...

Questions in other subjects: