Ask question

Ask question

All categories

2 years ago

10

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.

Computers and Technology

1 answer:

NeX [460]2 years ago

7 0

Answer:

WITH deptsalary AS (

SELECT dept, SUM(salary)

FROM emp

GROUP BY dept)

SELCT *

FROM deptsalary

Explanation:

deptsalary is temporary table.

dept and its respective sum of salary is to be displayed

You might be interested in

Why do agriculture and natural resource systems vary from state to state?

shepuryov [24]

Answer:

C

Explanation: This is because not every area is structured on the same ground as other places.

4 0

2 years ago

Oxnard Casualty wants to ensure that their e-mail server has 99.98 percent reliability. They will use several independent server

sattari [20]

Answer:

The smallest number of servers required is 3 servers

<em />

Explanation:

Given

$Reliability = 99.98\%$

$Individual Servers = 95\%$

Required

Minimum number of servers needed

Let p represent the probability that a server is reliable and the probability that it wont be reliable be represented with q

Such that

$p = 95\%\\$

It should be noted that probabilities always add up to 1;

So,

$p + q = 1$ '

Subtract p from both sides

$p - p + q = 1 - p$

$q = 1 - p$

Substitute $p = 95\%\\$

$q = 1 - 95\%$

Convert % to fraction

$q = 1 - \frac{95}{100}$

Convert fraction to decimal

$q = 1 - 0.95$

$q = 0.05$

------------------------------------------------------------------------------------------------

<em>To get an expression for one server</em>

The probabilities of 1 servers having 99.98% reliability is as follows;

$p = 99.98\%$

Recall that probabilities always add up to 1;

So,

$p + q = 1$

Subtract q from both sides

$p + q - q = 1 - q$

$p = 1 - q$

So,

$p = 1 - q = 99.98\%$

$1 - q = 99.98\%$

Let the number of servers be represented with n

The above expression becomes

$1 - q^n = 99.98\%$

Convert percent to fraction

$1 - q^n = \frac{9998}{10000}$

Convert fraction to decimal

$1 - q^n = 0.9998$

Add $q^n$ to both sides

$1 - q^n + q^n= 0.9998 + q^n$

$1 = 0.9998 + q^n$

Subtract 0.9998 from both sides

$1 - 0.9998 = 0.9998 - 0.9998 + q^n$

$1 - 0.9998 = q^n$

$0.0002 = q^n$

Recall that $q = 0.05$

So, the expression becomes

$0.0002 = 0.05^n$

Take Log of both sides

$Log(0.0002) = Log(0.05^n)$

From laws of logarithm $Loga^b = bLoga$

So,

$Log(0.0002) = Log(0.05^n)$ becomes

$Log(0.0002) = nLog(0.05)$

Divide both sides by $Log0.05$

$\frac{Log(0.0002)}{Log(0.05)} = \frac{nLog(0.05)}{Log(0.05)}$

$\frac{Log(0.0002)}{Log(0.05)} = n$

$n = \frac{Log(0.0002)}{Log(0.05)}$

$n = \frac{-3.69897000434}{-1.30102999566}$

$n = 2.84310893421$

$n = 3 (Approximated)$

<em>Hence, the smallest number of servers required is 3 servers</em>

6 0

2 years ago

In Python, which comparison operator means "less than or equal to"?

Komok [63]

Answer:

<=

Explanation:

Pretty much the same as in maths

3 0

2 years ago

Read 2 more answers

You work in an office that uses Linux and Windows servers. The network uses the IP protocol. You are sitting at a Windows workst

Aleksandr-060686 [28]

Answer:

PING

Explanation:

To check if there's still connectivity between the computer and server, I would use the ping command.

The ping command is primarily a TCP/IP command. What this command does is to troubleshoot shoot. It troubleshoots connection and reachability. This command also does the work of testing the name of the computer and also its IP address.

4 0

2 years ago

Unwanted emails are called:malware,phishing, spam or virus

Colt1911 [192]

1. Spam
2. Phishing
3. True

3 0

2 years ago