Question: Which tables and fields would you access to determine which book titles have been purchased by a customer and when the order shipped? Figure 1-5:

Which tables and fields would you access to determine which book titles have been purchased by a customer and when the order shipped?


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.32 Rating (158 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

CUSTOMERS Custome... 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_60b8c1211fc27_715963.pdf

180 KBs PDF File

Word file Icon

1803_60b8c1211fc27_715963.docx

120 KBs Word File

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