Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

write Relational Query of those SQL code A) SELECT location.locno, customer.custName FROM location,customer,facility WHERE facility.facNo= F100 wwwwww b) SELECT eventrequest.evnt No, eventrequest.custNo, customer.phone, eventrequest.dateReq, facility.facno,

write Relational Query of those SQL code 

2.PNG 

A) SELECT location.locno, customer.custName FROM location,customer,facility WHERE facility.facNo= "F100" wwwwww b) SELECT eventrequest.evnt No, eventrequest.custNo, customer.phone, eventrequest.dateReq, facility.facno, facility.facname, (eventrequest.estCost/eventrequest.estAudience) AS estimated audience cost per person C) FROM eventrequest, customer, facility www. www WHERE eventrequest.custno = customer.custno AND eventrequest.facNo = facility.facno AND eventrequest.dateReq BETWEEN "2013-01-01" AND "2013-07- 31" AND (eventrequest.estCost/eventrequest.estAudience) >0.1

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Programming With Microsoft Visual Basic 2017

Authors: Diane Zak

8th Edition

1337102121, 9781337517058, 978-1337102124

More Books

Students also viewed these Databases questions

Question

what is top - down parsing?

Answered: 1 week ago