Structure of the CUSTOMERS Table

question 123

Multiple Choice

Structure of the CUSTOMERS table

Structure of the ORDERS table

Structure of the ORDERITEMS table

Structure of the BOOKS table
-Which of the following SQL statements will display the names of all customers who have purchased a copy of E-BUSINESS THE EASY WAY?

• A) SELECT lastname, firstname FROM customers NATURAL JOIN books WHERE title LIKE '%BUSI%';
• B) SELECT lastname, firstname FROM customers c, books b, orders o, orderitems oi WHERE title LIKE '%BUSI%';
• C) SELECT lastname, firstname FROM customers c, books b, orders o, orderitems oi WHERE c.customer# = o.customer# AND o.order# = oi.order# AND Oi)isbn = b.isbn AND title LIKE '%BUSI%';
• D) none of the above

---

Definitions:

Young-Helmholtz Theory

A theory of color vision that proposes three types of cones in the retina, each sensitive to red, green, or blue light.

Blindsight

A condition where individuals can respond to visual stimuli without consciously perceiving them, often due to damage in the visual cortex.

Visual Cortex

The visual cortex is a part of the brain located in the occipital lobe that processes visual information received from the eyes.

Damage

Physical harm caused to something in such a way that it is impaired or its value or usefulness is decreased.