Draw output results for following queries Select Name, pQuantityPrice from Customer, Product where CID>5 AND description IN (‘Soap’,’Milk’) 2.Select Description, Sum(oQuantityPrice) FROM Customer c inner join Order o on c.CID=o.CID inner join Invoice i on i.OID=o.OID inner join Product p on p.PID=i.PID AND CITY=’Rawalpindi’ Group By Description Calculate the query cost of the given two relational queries. Write SQL query for both relational queries. PNAME (((sCITY!= ‘Rawat’(Customer)) ⋉CID(Order)) ⋈OID(soquantity!=3 (Invoice))) 2.PPrice(sPID=I.PID^O.OID=I.OID(((sPrice>30(Product)) x Invoice))x(soid!=3 (Order))) Write a procedure which takes order’s and invoice’s information as argument and insert data in relevant Before insertion make sure following points must not be violated. CID and PID must exists in Customer and product table respectively. oQuantity given for invoice table must be less than or equal to the quantity of that particular product exists in Product table. If product is cigarette, it must not be sold to customers whose age is less than 20. In that case data must not be inserted. Write a procedure which takes customer id as argument and return name of customer and his/her total bill of all orders. You must display Customer name and total bill which is returned by procedure in main body.

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Related questions

Question

Draw output results for following queries

Select Name, pQuantity*Price from Customer, Product where CID>5 AND description IN (‘Soap’,’Milk’)

2.Select Description, Sum(oQuantity*Price) FROM
Customer c inner join Order o on c.CID=o.CID
inner join Invoice i on i.OID=o.OID
inner join Product p on p.PID=i.PID
AND CITY=’Rawalpindi’
Group By Description

Calculate the query cost of the given two relational queries.
Write SQL query for both relational queries.

P_NAME(((s_{CITY!= ‘Rawat’}(Customer)) ⋉_CID(Order)) ⋈_OID(s_oquantity!=3(Invoice)))

2.P_Price(s_{PID=I.PID^O.OID=I.OID}(((s_Price>30(Product)) x Invoice))x(s_oid!=3(Order)))

Write a procedure which takes order’s and invoice’s information as argument and insert data in relevant Before insertion make sure following points must not be violated.
1. CID and PID must exists in Customer and product table respectively.
2. oQuantity given for invoice table must be less than or equal to the quantity of that particular product exists in Product table.
3. If product is cigarette, it must not be sold to customers whose age is less than 20. In that case data must not be inserted.

Write a procedure which takes customer id as argument and return name of customer and his/her total bill of all orders. You must display Customer name and total bill which is returned by procedure in main body.