Answer:
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.
