Structure of the CUSTOMERS Table

question 5

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 title of the books ordered by customer# 1003?​

• A) ​SELECT title FROM customers NATURAL JOIN books WHERE customer# = 1003;
• B) ​SELECT title FROM customers JOIN orders USING (customer#) JOIN orderitems USING (order#)JOIN books USING (isbn) WHERE customer# = 1003;
• C) ​SELECT title FROM customers JOIN orders ON (customer#) JOIN orderitems ON (order#)JOIN books ON (isbn) WHERE customer# = 1003;
• D) ​both a and b

---

Definitions:

Inference Forms

Patterns of reasoning where specific statements lead logically to a conclusion.

MP

In logic, MP refers to Modus Ponens, a form of argument that if a conditional statement ('If P then Q') is accepted, and P is affirmed, then Q must also be affirmed.

MT

An abbreviation or shorthand for Modus Tollens, a logical argument form.

Inference Forms

Standard logical structures that outline the relationship between premises and conclusion, guiding the derivation of the latter from the former.