Question: Consider the following schema: invoice (i-id, c-id, date, month, year, p-id, quantity, amount) Product(p-id, p-name, price, numbers-available) A) Write a function to get the

Consider the following schema: invoice (i-id, c-id, date, month, year, p-id, quantity, amount) Product(p-id,

Consider the following schema: invoice (i-id, c-id, date, month, year, p-id, quantity, amount) Product(p-id, p-name, price, numbers-available) A) Write a function to get the p-id and quantity of 2 different products and returns the total amount for the invoice B) Write a trigger to print the message "Stock is not available" if ordered quantity for one product is more than available numbers

Step by Step Solution

★★★★★

3.38 Rating (154 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

A Function to Calculate Total Amount for an Invoice You can write a function in SQL to calculate the ... 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

Students Have Also Explored These Related Programming Questions!

Kate is a self-taught tax preparer. She advertises tax preparation for low fees and does other people's returns as a business to make extra income. She makes no claims in her advertising or to...

The transactions listed below occurred at Jarred Company during 20X1: DATE Mar. 25 July 19 TRANSACTIONS Exchanged a printer (Office Equipment) that had an original cost of $5,320 when purchased on...

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

The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...

the shopping database For many query questions we refer to the following database schema for a website that keeps track of what people like to buy or actually buy in different on-line supermarkets....

1. Assume the following table- Degree (degcode, name, subject) Candidate (seatno, degcode, name, semester, month, year, result) Marks (seatno, degcode, semester, month, year, papcode, marks) [degcode...

The resulting bar chart shows that when HMK is the AR Clerk and FKL is the Cash Receipts Clerk, CT is the GL Accounting Clerk for $226,851 of current AR balances. However, there are $25,352 of...

IS3280 Data Management Assignment 5 Course Assignment SQL with One Table Submit via D2L. Please put your name in your file. You can do this assignment in Access. What is required to be turned in is...

The resulting bar chart shows that when HMK is the AR Clerk and FKL is the Cash Receipts Clerk, CT is the GL Accounting Clerk for $226,851 of current AR balances. However, there are $25,352 of...

Write out the augmented matrix for the following linear systems. Then solve the system by first applying elementary row operations of type #1 to place the augmented matrix in upper triangular form,...

Construct a list of a countrys economic statistics you would assemble to help determine the probability of a devaluation of its currency within the coming year.

1 0 Find a set o f parametric equations for the rectangular equation that satisfies the given condition. ( E n t e r your answers a s a comma - separated list. ) y = x 2 , t = 3 a t the point ( 3 , 9...

1. Determine whether the following series converge, and if so, find the sum (a) (2 points) (2i)" (b) (2 points) n0 0= +nin/3 (c) (2 points) (i)"+1 n=0 n!

Create an organizational chart to represent the ideal structure for your current organization (or one with which you are familiar). You should include: the type of structure (divisional structure,...

An investment allows for end-of-year payments that grow by 4% per payment for 20 years, starting with $2,000 at the end of the first year. If the payments earn 4% compounded annually, how much...

You are controlling the descent of two crates that are sliding down a sloping floor, as shown in the figure.(Figure 1) You pull on a rope parallel to the sloping floor. The top crate sits atop the...

Show that if x is a nonzero column vector in R n , then the n n matrix A= I n (2 /x 2 ).xx T is both orthogonal and symmetric.

Which of the following is not associated with product stewardship?Group of answer choicesreduction in costsdesign for reuse and recyclabilityreduce productivitytakeback programs

Some restaurants use customer checks with pre-numbered sequence codes. Each food server uses these checks to write up customer orders. Food servers are told not to destroy any customer checks; if a...

Match the terms with theirdefinitions: 1. Virtual private a. A hash encrypted with the creator's private key network (VPN) Data loss prevention 2. b. A company that issues pairs of public and private...

Excel Project a. Expand the cash budget you created in Problem 12.4 to include a row for expected cash outflows equal to 77% of the current months sales. b. Also add a row to calculate the amount of...

How might the growth in use of the Internet affect consumer response to traditional marketing communication activities?

What communication tools are used close to the buyer decision point?

Review your working situation. Tabulate some examples of activities and actions than can be explained by the transmission model and others that require a cultural model of communication. What...