Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

CUSTOMERS(customer#, lastName, firstName, address, city, state, zip, referred) ORDERS( order#, customer#, orderDate, shipDate, ShipStreet, ShipCity, ShipZip) BOOKS (isbn, title, pubDate, pubId, cost, retail, category) ORDERITEMS(order#,

CUSTOMERS(customer#, lastName, firstName, address, city, state, zip, referred) ORDERS( order#, customer#, orderDate, shipDate, ShipStreet, ShipCity, ShipZip) BOOKS (isbn, title, pubDate, pubId, cost, retail, category) ORDERITEMS(order#, item#, isbn, quantity) Which of the following SQL statements will display the names of all customers who have purchased a copy of PLAGIARISM TOOLS (book title)?

a.SELECT lastName, firstName FROM orders o, customers c, books b, orderitems oi WHERE c.customer#=o.customer# AND o.order#=oi.order# AND oi.isbn=b.isbn AND title LIKE %PLAG%;

b.SELECT lastName, firstName FROM customers c, books b, orderitems oi WHERE title LIKE %PLAG%;

c.none of the options

d.SELECT lastName, firstName FROM customers NATURAL JOIN books WHERE title LIKE %PLAG%;

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

Modern Database Management

Authors: Jeffrey A. Hoffer Fred R. McFadden

4th Edition

0805360476, 978-0805360479

More Books

Students also viewed these Databases questions

Question

How is the NDAA used to shape defense policies indirectly?

Answered: 1 week ago