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

Another question on Computers and Technology

question
Computers and Technology, 21.06.2019 18:00
Is the following sentence true or false? during meiosis, the two alleles for each gene stay together.
Answers: 3
question
Computers and Technology, 22.06.2019 21:00
Which of these is most responsible for differences between the twentieth century to the twenty-first century?
Answers: 2
question
Computers and Technology, 23.06.2019 02:30
People with high self-esteem: accept their strengths and weaknesses. believe that failed experiences are failures of their whole self. feel good about who they are only when they reach total success. need positive external experiences to counteract negative feelings that constantly plague them.
Answers: 1
question
Computers and Technology, 23.06.2019 19:30
You can apply several different worksheet themes from which tab?
Answers: 1
You know the right answer?
Consider the following relation schemas: Department (dnumber, dname, employee_count), PK: dnumber. E...
Questions
question
Mathematics, 03.03.2021 23:50
question
English, 03.03.2021 23:50
question
Biology, 03.03.2021 23:50
question
Mathematics, 03.03.2021 23:50
question
English, 03.03.2021 23:50
question
Mathematics, 03.03.2021 23:50
Questions on the website: 13722363