Case-Based Critical Thinking Questions Case 3-3
Ja'nice launched an online jewelry business several months ago to sell her handmade jewelry. As her business expanded, Ja'nice developed product codes for her jewelry and a database to track orders, track supply orders, and maintain customer information. The tables and fields in her database are illustrated in the figure below.

Ja'nice would also like to create a query that shows her specific products (by Product ID) that were purchased by individual customers. To do this, she must use at last two tables to create the query. Which two tables would be best to use for this query?
A) Customer Info and Product Info
B) Order Info and Product Info
C) Customer Info and Order Info
D) Order Info and Vendors

Question

Case-Based Critical Thinking Questions Case 3-3
Ja'nice launched an online jewelry business several months ago to sell her handmade jewelry. As her business expanded, Ja'nice developed product codes for her jewelry and a database to track orders, track supply orders, and maintain customer information.  The tables and fields in her database are illustrated in the figure below.

Ja'nice would also like to create a query that shows her specific products (by Product ID) that were purchased by individual customers.  To do this, she must use at last two tables to create the query.  Which two tables would be best to use for this query?
A) Customer Info and Product Info 
B) Order Info and Product Info 
C) Customer Info and Order Info 
D) Order Info and Vendors

Quizplus · Accepted Answer

The Answer of Case-Based Critical Thinking Questions Case 3-3
Ja'nice launched an online jewelry business several months ago to sell her handmade jewelry. As her business expanded, Ja'nice developed product codes for her jewelry and a database to track orders, track supply orders, and maintain customer information.  The tables and fields in her database are illustrated in the figure below.

Ja'nice would also like to create a query that shows her specific products (by Product ID) that were purchased by individual customers.  To do this, she must use at last two tables to create the query.  Which two tables would be best to use for this query?
A) Customer Info and Product Info 
B) Order Info and Product Info 
C) Customer Info and Order Info 
D) Order Info and Vendors