Alpha Geek

(8)

$10/per page/Negotiable

About Alpha Geek

Levels Tought:
University

Expertise:
Accounting,Algebra See all
Accounting,Algebra,Architecture and Design,Art & Design,Biology,Business & Finance,Calculus,Chemistry,Communications,Computer Science,Environmental science,Essay writing,Programming,Social Science,Statistics Hide all
Teaching Since: Apr 2017
Last Sign in: 438 Weeks Ago, 2 Days Ago
Questions Answered: 9562
Tutorials Posted: 9559

Education

  • bachelor in business administration
    Polytechnic State University Sanluis
    Jan-2006 - Nov-2010

  • CPA
    Polytechnic State University
    Jan-2012 - Nov-2016

Experience

  • Professor
    Harvard Square Academy (HS2)
    Mar-2012 - Present

Category > Programming Posted 09 May 2017 My Price 10.00

Consider the COMPANY database described in Figure

Exercise 24.15

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

 

 

 

Oct 14 2016 02:45 PM

Answers

Alpha Geek
(8)
Status NEW Posted 09 May 2017 10:05 AM My Price 10.00

-----------

Attachments

file 1494324799-Answer.docx preview (159 words )
E-----------xer-----------cis-----------e 2-----------4.1-----------5 -----------Con-----------sid-----------er -----------the----------- CO-----------MPA-----------NY -----------dat-----------aba-----------se -----------des-----------cri-----------bed----------- in----------- Fi-----------gur-----------e 5-----------.6.----------- Us-----------ing----------- th-----------e s-----------ynt-----------ax -----------of -----------Ora-----------cle----------- tr-----------igg-----------ers-----------, w-----------rit-----------e a-----------cti-----------ve -----------rul-----------es -----------to -----------do -----------the----------- fo-----------llo-----------win-----------g: ----------- a.----------- Wh-----------ene-----------ver----------- an----------- em-----------plo-----------yee-----------&am-----------p;a-----------mp;-----------#39-----------;s -----------pro-----------jec-----------t a-----------ssi-----------gnm-----------ent-----------s a-----------re -----------cha-----------nge-----------d, -----------che-----------ck -----------if -----------the----------- to-----------tal----------- ho-----------urs----------- pe-----------r w-----------eek----------- sp-----------ent----------- on----------- th-----------e e-----------mpl-----------oye-----------e&a-----------mp;-----------amp-----------;#3-----------9;s----------- pr-----------oje-----------cts----------- ar-----------e l-----------ess----------- th-----------an -----------30 -----------or -----------gre-----------ate-----------r t-----------han----------- 40-----------; i-----------f s-----------o, -----------not-----------ify----------- th-----------e e-----------mpl-----------oye-----------e&a-----------mp;-----------amp-----------;#3-----------9;s----------- di-----------rec-----------t s-----------upe-----------rvi-----------sor-----------. -----------b. -----------Whe-----------nev-----------er -----------an -----------EMP-----------LOY-----------EE -----------is -----------del-----------ete-----------d,
Not Rated(0)