Which tables and fields would you access to determine which book titles have been purchased by a customer and when the order shipped

To determine which book titles have been purchased by a customer and when the order shipped the following tables and fields would be used.

Table:      

Fields

Table

Fields:

Table:

Fields:

Table:

Fields

BOOKS table contains field like title of the books, so this will help in finding which book titles have been purchased.

CUSTOMERS table keeps information about customers that purchasing an ordering the books. The customerno uniquely identifies each customer so that the order information can be found using the customerno of a specific customer.

ORDERITEMS keeps information about orders via orderno

ORDERS table will keep track about the shipment of orders. Orderno identifies each order, shipdate will help determine when an order is shipped.