Question: Please use SQL/PQSQL not MYSQL Create audit table which will be populated each time a books retail price or cost is changed. The name, what

Please use SQL/PQSQL not MYSQL

Create audit table which will be populated each time a books retail price or cost is changed. The name, what fields you include in the audit table and it's intended use are for you to determine.

Create trigger to populate the audit table described above

Create function which returns the average retail price of all books in the books table

Create procedure which utilizes a cursor to update the retail price of all books in the books by a given percentage. The table that is used is below.

CREATE TABLE Books (ISBN VARCHAR2(10), Title VARCHAR2(30), PubDate DATE, PubID NUMBER (2), Cost NUMBER (5,2), Retail NUMBER (5,2), Discount NUMBER (4,2), Category VARCHAR2(12), CONSTRAINT books_isbn_pk PRIMARY KEY(isbn), CONSTRAINT books_pubid_fk FOREIGN KEY (pubid) REFERENCES publisher (pubid))

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

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

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...

Let A, B be sets. Define: (a) the Cartesian product (A B) (b) the set of relations R between A and B (c) the identity relation A on the set A [3 marks] Suppose S, T are relations between A and B, and...

In the following exercises, you will use the data in the TAL Distributors database shown in Figure 2-1 in Chapter 2. (If you use a computer to complete these exercises, use a copy of the original TAL...

I am using Oracle SQLDeveloper environment and need some assistance or guidance with the creation of the following: Creation of an audit table which will be populated each time a books retail price...

Oracle SQL Questions: ( I have answered the questions and the first two statements work, but I keep getting errors with the 3rd and 4th statement). 1. Creation of an audit table which will be...

Part A. You are a Database Administrator working for a small software solutions firm. You have been assigned to help develop a beverage imports management system. High Spirits is a small importing...

You are a Database Administrator working for a small software solutions firm. You have been assigned to help develop a beverage imports management system. High Spirits is a small importing company...

Overview Nineteen67apparel is an apparel e-commerce company in London Ontario. This town is heavily populated with university students and young professionals, the total population of university...

Hobart Ltd. has the number of shares of ordinary shares outstanding 513,000,000 , and the current price per share is 56. If the company's profit is $ 890,000,000.00. Calculate the PE ratio and would...

Solex Company manufactures three products from a common input in a joint processing operation. Joint processing costs up to the split-off point total $100,000 per year. The company allocates these...

P12.12 Consider a control system with the plants model == x(t) = Ax(t) + Bu(t) y(t) = Cx(t), 0 1 0 where A = 0 0 1-8- -9-6-4 C=[010] B=0 and The system uses output feedback u(t) = r(t) - Ky(t), where...

Derive the expected mean squares for a balanced three-stage nested design, assuming that A is fixed and that B and C are random. Obtain formulas for estimating the variance components. Assume the...

The two attached pulleys are driven by the belt with increasing speed. When the belt reaches a speed v = 2 ft/sec, the total acceleration of point P is 26 ft/sec 2 . For this instant determine the...

The tensile strengths of wires in a certain lot of size 400 are specified to exceed 5 kilograms. Consider an acceptance sampling plan based on a sample of n = 10 wires and acceptance number = 1. a....

You are talking to the victim of a violent crime in the emergency room. Her boyfriend barges in and demands to know whats going on. Who owns the problem? In the above situations, identify who owns...

Shortly after her lawsuit against the computer company was resolved, Trina took her new laptop into a computer store for needed repairs. When Trina returned to pick it up, she found it had been sold...

In a typical supply chain, raw materials are procured and items are produced at one or more factories, shipped to warehouses for intermediate storage, and then shipped to retailers or customers. True...

Leeft Bank offers to reduce the collection time for your company's daily cash receipts by two days with its cash management system. This service will cost you $15,000 per year. Currently, short-term...

The following information was available as of the close of business June 1, 2004, on government of Canada bonds. Calculate the anticipated one-year interest rate for 2006 (up to June 2007). Coupon...

Boatler Used Cadillac Co. requires $850,000 in financing over the next three years. The firm can borrow the funds for two years at 8 percent interest per year. Mr. Boatler decides to do forecasting...

This problem demonstrates the dramatic effect that consolidation accounting can have on a company's ratios. Randall Motor Company (Randall) owns 100% of Randall Motor Credit Corporation (RMCC), its...

The Cola Company reported the following comparative information at December 31, 2017, and December 31, 2016 (amounts in millions and adapted): Requirements 1. Calculate the following ratios for 2017...

Financial institutions hold large quantities of bond investments. Suppose Sun Life Financial purchases $500,000 of 6% bonds of General Components Corporation for 88 on January 1, 2017, when the...