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

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 person. Your rules should also check if the SUM_COMMISSIONS exceeds 100000; if it does, call a procedure NOTIFY_MANAGER(S_ID). Write both statement-level rules in STARBURST notation and row-level rules in Oracle.

Step by Step Solution

★★★★★

3.52 Rating (162 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Oracle notation rules CREATE TRIGGER KEEPEMSAME AFTER INSERT OR UPDATE OF COMMISION ON SALES FOR EAC... 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 (2341).docx

120 KBs Word File

Students Have Also Explored These Related Databases Questions!

Consider the relational schema shown in Figure below. a. Give a schema definition in SQL: 1999 corresponding to the relational schema, but using references to express foreign-key relationships. b....

Using ODMG C++ a. Give schema definitions corresponding to the relational schema shown in Figure, using references to express foreign-key relationships. b. Write programs to compute each of the...

Consider the relational schema for the Hotel case study given in the Exercises at the end of Chapter 4. Redesign this schema to take advantage of the new features of SQL:2011. Add user-defined...

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

Managerial Decision Making Six Decision Stages in Chapter 5 I. Identify and Diagnose the Problem Consider the following questions when identifying and diagnosing the problem: Is there a difference...

CHAPTER 1 THE BUSINESS AND SOCIETY RELATIONSHIP BUSINESS & SOCIETY Title ISBN Business and Society Archie B. Carroll; Ann K. Buchholtz 978-1-285-73429-3 Publisher Cengage Learning Author FOCUS OF THE...

Completion Criteria: For the Pass Task to be marked "Complete" nine ( 9 ) sub - tasks must be marked "Correct". Pass 4 a Consider the Relational Schema shown below. It has been created from an ERD...

PART II - Relational Algebra Queries Consider the relational schema below and answer the next 6 questions. PK stands for primary key, and FK for foreign key. Not all the schema is shown, but you do...

Consider the following relational schema: Staff ( staffNo , name, dept, skillCode) Skill ( skillCode , description, chargeOutRate) Project ( projectNo ,...

What is the purpose of normalisation ? What problems does normali- sation gets rid of? When is it used? Consider the relational schema R with key ( a, b, c ) and no alternative keys. Below all its...

Why are many developers reluctant to redevelop brown field areas?

Frank is a single-father with one child. The cost of child-care is equivalent to $150 per day. When Frank works, he receives an hourly wage of $20. In addition, he has $150 of non-labor income per...

year end is on july 31, 2024, on june 1, 2024 you sign a 3 month, 3%, 50,000 note. What is the interest expense for the year end july 31 income statement

Carrboro High School is having a car wash to raise money for a Spring Break trip to Amsterdam. Eight students are working at the car wash. Jill and Kelly are on the sidewalk holding signs advertising...

Consider the LIBRARY relational database schema shown in Figure 8.14, which is used to keep track of books, borrowers, and book loans. Referential integrity constraints are shown as directed arcs in...

Specify the following queries in relational algebra on the database schema given in Exercise 5.14: a. List the Order# and Ship_date for all orders shipped from Warehouse# W2. b. List the WAREHOUSE...

Specify the following queries in relational algebra on the database schema given in Exercise 5.15: Exercise 5.15 Consider the following relations for a database that keeps track of business trips of...

Presume the following Income Statement ABC Corp. Sales 49,000 Costs 40,300 Taxable income 8,700 Taxes (21%) 1.914 Net Income 6,786 Dividends 2,400 Addition to Retained Earnings ? Prepare the Proforma...

Allied Biscuit Co. has to choose between two mutually exclusive projects. If it chooses project A, Allied Biscuit Co. will have the opportunity to make a similar investment in three years. However,...

What is the average time a customer waits for service? What is the average number of customers waiting in the line for their turn to receive a haircut What is the average number of customers in the...