Question: Repeat 26.34 but use the syntax of STARBURST active rules. In repeat 26.34 (a) Whenever an employee's project assignments are changed, check if the total

Repeat 26.34 but use the syntax of STARBURST active rules.
In repeat 26.34
(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.43 Rating (169 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

a We assume that a procedure TELLSUPERVISORARGSSNS has been created This procedure looks ... 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 (2340).docx

120 KBs Word File

Students Have Also Explored These Related Databases Questions!

Consider the relational schema shown in Figure 26.18. Write active rules for keeping the SUM_COMMISSIONS attribute of SALES_PERSON equal to the sum of the COMMISSION attribute in SALES for each sales...

Demonstrate how to use Pythons list comprehension syntax to produce the list ['a', 'b', 'c', ..., 'z'], but without having to type all 26 such characters literally.

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...

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...

As she drove, Beck reflected on all that had transpired in her career since she earned her MBA in 2002. She had started her business, Beck Consulting Corporation (BCC) a year after graduation. Over...

In November 2019, Transport for London (TfL), the transportation authority of the British capital, denied Uber a new license to operate in Greater London. TfL claimed that Uber exhibited a "pattern...

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...

Discuss Semantics and the challenges they are in English. 2 Language Structure and Use Learning Outcomes After reading this chapter, you should be able to ... Explain how language contributes to...

7 Writing in the Workplace If writing must be a precise form of communication, it should be treated like a precision instrument. It should be sharpened, and it should not be used carelessly. Theodore...

Module 9 Assignment: TOC Answer all the questions and submit your answer report to Module 9 Assignment in Dropbox by the deadline . The report should be typed, single spaced, in one MS Word file. You...

.Solve for u, x, y, and z in the matrix equation: 1 x 2-21 L0 3 3z 10 %3! 2y -3 4 -U 7 u = 15, x= 2, y = 2, z = - 7. O b. u = 15, x = -2, y= 2, z = . Ocu= 2, x = 15, y 2, z = - 3 3 O d. u = 2, x =...

x3 - 4x2 + 4x +1 cross its oblique asymptote? Will the graph of the function f(x) O Yes O No

18.9 What are the four defining characteristics of a financial intermediary?

Two teaching assistants work in a homework help room. They can each serve up to two students, but get less efficient when there are helping two at once. Students arrive at rate 3 but will not go in...

Discuss the meanings of the existential quantifier () and the universal quantifier ().

Define the following terms with respect to the tuple calculus: tuple variable, range relation, atom, formula, and expression.

Define the following terms with respect to the domain calculus: domain variable, range relation, atom, formula, and expression.

a. List and discuss two (2) differences between the Know Your Client Form and the Investment Policy Statement. (4 Marks) b. Managers can select stocks either from the sector level or at the...

Please help with this whole probelm. The drop down box gives the choices of expand or abandon. Introduction to real options Consider the following statement about real options: True or False: The...

Suppose you bought a bond with a coupon rate of 7.5 percent one year ago for $898. The bond sells for $928 today. 1) Assuming a $1,000 face value, what was your total dollar return on this investment...