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.

After choosing the two tables for the new query, Ja'nice must relate the two tables using a common field. What is the common field between the two tables?
A) Product ID
B) Customer ID
C) Date
D) Product

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.

After choosing the two tables for the new query, Ja'nice must relate the two tables using a common field.  What is the common field between the two tables?
A) Product ID 
B) Customer ID 
C) Date 
D) Product

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.

After choosing the two tables for the new query, Ja'nice must relate the two tables using a common field.  What is the common field between the two tables?
A) Product ID 
B) Customer ID 
C) Date 
D) Product