Computers and Technology, 07.04.2020 04:54, angela563

Suppose you are given a relation emp(empid, dept, salary) and wish to maintain a materialized view deptsalary(dept, totalsalary) which stores the total salary for all employees of each department. Suppose the system does not support materialized views but supports triggers. Write an SQL trigger on insert on emp to keep the relation deptsalary up to date. Do not worry about deletes or updates. You can assume that there is already a tuple for each department in deptsalary so you do not need to worry about new deparments.

Answers: 1

Show answers

Other questions on the subject: Computers and Technology

Computers and Technology, 22.06.2019 23:30, jhonpiper

For her science class, elaine is creating a presentation on weather in the united states. she wants to make the presentation beautiful and interesting by drawing simple cloud or wave shapes. which is the best way for elaine to draw these shapes?

Answers: 1

continue

Computers and Technology, 23.06.2019 21:40, gaby06

Simon says is a memory game where "simon" outputs a sequence of 10 characters (r, g, b, y) and the user must repeat the sequence. create a for loop that compares the two strings. for each match, add one point to user_score. upon a mismatch, end the game. sample output with inputs: 'rrgbryybgy' 'rrgbbrybgy'

Answers: 3

continue

Computers and Technology, 24.06.2019 07:40, daebreonnakelly

What type of multimedia are live news feeds? live news feeds are examples of multimedia.

Answers: 2

continue

Computers and Technology, 24.06.2019 23:00, Kaziyah461

People should never use telepresence when virtually meeting with a group of co-workers. true false

Answers: 1

continue

Do you know the correct answer?

Suppose you are given a relation emp(empid, dept, salary) and wish to maintain a materialized view d...