Consider the following database schemeEmployee (SSN, fname, lname, salary, deptno)Department (deptno, dname, total_salary)Where total salary is a derived attribute that represents the total salary of employees working in a specific department.Write a trigger to compute the total_salary in the event of inserting one or more new employee record(s) in the employee table. Consider the following database schemeEmployee (SSN, fname, Iname, salary, deptno)/Department (deptno, dname, total_salary)Where total salary is a derived attribute that represents the total salary ofemployees working in a specific department.Write a trigger to compute the total_salary in the event of inserting one ormore new employee record(s) in the employee table.

Employee salary (Emp Salary) has an impact on the overall department salary. First, let me tell you…

Answered: Consider the following database scheme…

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

Related questions

Question

Consider the following database scheme

Employee (SSN, fname, lname, salary, deptno)

Department (deptno, dname, total_salary)

Where total salary is a derived attribute that represents the total salary of employees working in a specific department.

Write a trigger to compute the total_salary in the event of inserting one or more new employee record(s) in the employee table.

Consider the following database scheme
Employee (SSN, fname, Iname, salary, deptno)/
Department (deptno, dname, total_salary)
Where total salary is a derived attribute that represents the total salary of
employees working in a specific department.
Write a trigger to compute the total_salary in the event of inserting one or
more new employee record(s) in the employee table.

Expert Solution

Step 1

Employee salary (Emp Salary) has an impact on the overall department salary.
First, let me tell you the Total_Salary of the department is directly dependent on the employee's salary. If the salary of an employee will change then the total salary of the employee will also be changed because the department
Total_Salary is the sum of all employer's salaries in that department.
Dept_No also affects the Total_Salary of the department
If the department number of an employee is changed or the employee is transferred to some other department.
So the total number of an employee in the department will be changed. Because when an employee leave’s old department then a total number of an employee in that department is decreased and the sum of salary of all employee in that department also decreases. The same thing when an employee joins a new department and the total number of employees in that department increases so the total sum salary of all employees in that department also increases. That is why Dept_No is also affecting the Total_Salary of the department

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions