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.
The bubble sort makes multiple passes through a list. It compares adjacent items and exchanges those that are out of order. Each pass through the list places the next largest value in its proper place. In essence, each item “bubbles” up to the location where it belongs.
