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 wants to create a query that will show her all orders placed on or after July 1, 2015. Which table does Ja'nice need to use for this query?
A) Customer Info
B) Product Info
C) Vendors
D) Order Info

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 wants to create a query that will show her all orders placed on or after July 1, 2015.  Which table does Ja'nice need to use for this query?
A) Customer Info 
B) Product Info 
C) Vendors 
D) Order Info

Quizplus · Accepted Answer

Ja'nice needs to know about the orders placed on or after July 1, 2015. Therefore, she needs to use the "Order Info" table which contains the date of every order placed. The other tables (Customer Info, Product Info, and Vendors) are not relevant for this query.