Structure of the CUSTOMERS table

Structure of the ORDERS table
Structure of the ORDERITEMS table
Structure of the BOOKS table
-To display the name of each customer and the title of each book purchased by the customers would require how many join conditions?
A) 4
B) 3
C) 2
D) 1

Question

Structure of the CUSTOMERS table
  ​
Structure of the ORDERS table
  Structure of the ORDERITEMS table
  Structure of the BOOKS table
-​To display the name of each customer and the title of each book purchased by the customers would require how many join conditions?
A) ​4 
B) ​3 
C) ​2 
D) ​1

Quizplus · Accepted Answer

To display the name of each customer and the title of each book purchased, we need to link the CUSTOMERS table with ORDERS table using the common column "CustomerID", then link the ORDERS table with ORDERITEMS table using the common column "OrderID", and finally link the ORDERITEMS table with BOOKS table using the common column "BookID". This requires three join conditions.

Structure of the CUSTOMERS Table