Question

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

Answer 1

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:      

• CUSTOMERS

Fields

• Customerno

Table

• ORDERS

Fields:

• Orderno

• Shipdate

• Customerno

Table:

• ORDERITEMS

Fields:

• Orderno

Table:

• BOOKS

Fields

• isbn

• title

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.