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. 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. Consider the following database schema and do as directed.ProductOrderPID Description pQuantity PriceShampooSoapDetergentMilkOIDDateCID23/5/201224/5/2012130050114040223030423/4/20164143312/2/20161Lemon Max102010/1/20162.Chocolate7 Cigarettes6343430150CustomerInvoiceCID NameСITYAgeOIDPIDoQuantity1Rawalpindi 23Ahmad Islamabad 451Ali11.1.1.42ChakwalIslamabad 34Shafiq Islamabad 423Umer33314Karim52316.WaleedRawat192334243

Answered: Draw output results for following…

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

Concept explainers

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.

Consider the following database schema and do as directed.
Product
Order
PID Description pQuantity Price
Shampoo
Soap
Detergent
Milk
OID
Date
CID
23/5/2012
24/5/2012
1
300
50
1
140
40
2
230
30
4
23/4/2016
4
14
33
12/2/2016
1
Lemon Max
10
20
10/1/2016
2.
Chocolate
7 Cigarettes
6
34
34
30
150
Customer
Invoice
CID Name
СITY
Age
OID
PID
oQuantity
1
Rawalpindi 23
Ahmad Islamabad 45
1
Ali
1
1.
1.
1.
4
2
Chakwal
Islamabad 34
Shafiq Islamabad 42
3
Umer
33
3
1
4
Karim
5
2
3
1
6.
Waleed
Rawat
19
2
3
3
4
2
4
3

Expert Solution

Step 1

As per our guidelines, we are supposed to answer only one question. Kindly repost the remaining questions separately.

Given Query:

SELECT Name, pQuantity*Price

FROM Customer, Product

WHERE CID>5 AND description IN (‘Soap’,’Milk’)

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-engineering and related others by exploring similar questions and additional content below.

Recommended textbooks for you

Computer Networking: A Top-Down Approach (7th Edi…

Computer Engineering

ISBN:

9780133594140

Author:

James Kurose, Keith Ross

Publisher:

PEARSON