Question: Consider the COMPANY database described in Figure 3.6. Using the syntax of Oracle triggers, write active rules to do the following: (a) Whenever an employee's

Consider the COMPANY database described in Figure 3.6. Using the syntax of Oracle triggers, write active rules to do the following:
(a) Whenever an employee's project assignments are changed, check if the total hours per week spent on the employee's projects are less than 30 or greater than 40; if so, notify the employee's direct supervisor.
(b) Whenever an EMPLOYEE is deleted, delete the PROJECT tuples and DEPENDENT tuples related to that employee, and if the employee is managing a department or supervising any employees, set the MGRSSN for that department to null and set the SUPERSSN for those employees to null.

Step by Step Solution

★★★★★

3.45 Rating (168 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

a We assume that a procedure TELLSUPERVISORARGSSN has been create... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Document Format (1 attachment)

888-CS-DB (2339).docx

120 KBs Word File

Students Have Also Explored These Related Databases Questions!

Using a table similar to that shown in Figure 3.6, calculate the product of the octal unsigned 6-bit integers 62 and 12 using the hardware described in Figure 3.3. You should show the contents of...

Using a table similar to that shown in Figure 3.6, calculate the product of the hexadecimal unsigned 8-bit integers 62 and 12 using the hardware described in Figure 3.5. You should show the contents...

Using a table similar to that shown in Figure 3.10, calculate 74 divided by 21 using the hardware described in Figure 3.8. You should show the contents of each register on each step. Assume both...

Consider the COMPANY database described in Figure 5.6. Using the syntax of Oracle triggers, write active rules to do the following: a. Whenever an employees project assignments are changed, check if...

Consider the Company Database given in the handout. This Database contains 6 relations, namely: EMPLOYEE, DEPARTMENT, DEPT_LOCATION, WORKS_ON, PROJECT and DEPENDENT. Each table is defined in the...

Database Administration CHAPTER OBJECTIVES I Understand the need for and importance of database I ttno'illI the meaning of ACID transaction administralin - Learn the tour 1992 ANSI standard isolation...

1 McKraklin AEROSPACE (A) "First you figure out what's inevitable. Then you find a way to take advantage of it." Russell Ackoj INTRODUCTION Dave Costner, Director of Information Systems (IS), shook...

There are two problems due this week (each worth 35 points) as follows. Problem 1.6 (page 20) In comprehensive paragraphs, answerrequirements a to e. You will have 5 paragraphs total of four to five...

Read Classroom Glimpse. Discuss stress, rhythm, pitch, and intonation based on the tale in the classroom 2 Language Structure and Use Learning Outcomes After reading this chapter, you should be able...

Ghostbusters Corporation issues $300,000 of 9% bonds, due in 10 years, with interest payable semiannually. At the time of issue, the market rate for such bonds is 10%. Compute the issue price of the...

(a) Find the Taylor-series expansion about x = 0 for ex. (b) Use the Taylor series (about x = 0) of sin x, cos x, and ex to verify that ei = cos + i sin [Eq. (1.28)].

What must be the beta of a portfolio with E ( rP ) = 2 0 % , if rf = 5 % and E ( rM ) = 1 2 % ? ( Round your answer to 2 decimal places. ) Beta of portfolio

Consider a taxi station at an airport where taxis and (groups of) customers arrive at times of Poisson processes with rates 2 and 3 per minute. Suppose that a taxi will wait no matter how many other...

What is the FUNCTION operation? For what is it used?

How are the OUTER JOIN operations different from the INNER JOIN operations? How is the OUTER UNION operation different from UNION?

In what sense does relational calculus differ from relational algebra, and in what sense are they similar?

Need help with D Below: Consolidated Pasta is currently expected to pay annual dividends of $10 a share in perpetuity on the 2.7 million shares that are outstanding. Shareholders require a 10% rate...

At the time of her grandson's birth, a grandmother deposits $1000 in an account that pays 8% compounded monthly. What will be the value of the account at the child's twenty-first birthday, assuming...

QUESTIONS REIT Inc. paid a dividend of 52 per share per year on its common stock in past 10 years. And it is expected to continue paying two dollars a share long in future. From the info, one share...