Question

Consider the following relational schema for a Product Sales database application:

Product (Prodid, Prodesc, Price, Stock)

Purchase (Purid, Proid, qty, supplierName)

Sales (Saleid, Proid, qty, custname)

a. Display the ProdID and the sum of quantity purchased for each product.

b. Create a sequence named Product_Sequence that gets incremented by 10 and use it for
inserting Prodid values in Product table.

c. Develop a procedure named Product_Sales that accepts a prodid and displays all the sales

and purchase records of it.

d. In the above procedure include exception in the procedure that will display a message

“No such Product ID” if the given product id does not exist in the product table.​

Answer 1

Answer:

mark me as a brainliest

Explanation:

100000000000000000000000% i need these much of brainliest

100000000000000000000000% i need these much of brainliest

Answer 2

Answer:

this ans pls send

Explanation:

this is my laboratory pls help me