Case-Based Critical Thinking Questions Case 3-3

question 92

Multiple Choice

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

---

Definitions:

Chi-Squared Goodness-Of-Fit

A statistical test used to determine if a sample data matches a population with a specified distribution, often used to assess the adequacy of fitting observed data to theoretical models.

Left-Tailed Area

The area under the curve of a probability distribution to the left of a specified value, used in hypothesis testing.

Degrees of Freedom

The number of independent values or quantities which can be assigned to a statistical distribution or to a system, minus the number of linear constraints.

Table Value

A specific value found in a statistical table, often used as a reference point for data analysis or hypothesis testing.