Case-Based Critical Thinking Questions Case 3-3

question 96

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.

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

---

Definitions:

Counselor

A professional who provides guidance on personal, social, or psychological issues, often using therapeutic techniques.

Psychiatrists

Physicians who specialize in the treatment of psychological disorders.

Insight Therapy

A form of psychotherapy focusing on the patient's self-awareness and understanding of the origins and meanings of their thoughts, feelings, and behaviors.

Psychotherapy

A method of treating mental health problems through talking with a psychiatrist, psychologist, or other mental health provider.