Question: If a customer inquired about a book written in 2003 by an author named Thompson, which access path (tables and fields) would you need to

If a customer inquired about a book written in 2003 by an author named Thompson, which access path (tables and fields) would you need to follow to find the list of books meeting the customer€™s request?


Figure 1-5:

ORDERS Order# Customer# Orderdate Shipdate Shipstreet Shipcity Shipstate Shipzip Shipcost CUSTOMERS Customer# Lastname F

ORDERS Order# Customer# Orderdate Shipdate Shipstreet Shipcity Shipstate Shipzip Shipcost CUSTOMERS Customer# Lastname Firstname Email Address City State Zip Referred Region BOOKAUTHOR AUTHOR BOOKS AuthorID ISBN ISBN AuthorID Lname ORDERITEMS Title Pubdate PubID Fname Order# Item# Cost Retail ISBN Quantity Paideach Discount PUBLISHER Category PubID Name PROMOTION Contact Phone Gift Minretail Maxretail

Step by Step Solution

3.45 Rating (155 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

AUTHOR Lname ... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Document Format (2 attachments)

PDF file Icon

1803_60b8c1211fe4a_715967.pdf

180 KBs PDF File

Word file Icon

1803_60b8c1211fe4a_715967.docx

120 KBs Word File

Students Have Also Explored These Related Oracle 12c SQL Questions!