Draw (i.e., a picture of) a database for the situation below. Your dia-
gram should depict whatever database organization is most meaningful to you;
please include enough words to explain what each part of your diagram repre-
sents. Use whatever notation you wish, but provide a notation legend so that
others can interpret your diagram. Assume you are head of Customer Service
86 Sales. — o —————

Bloomington Controls (BC) is a $5M manufacturer of components and systems
for the heating and air conditioning industry. BC has been in business for
twenty years and has a base of approximately 2000 customers.  Thirty to fourty
customer orders are received every day: a backlog of 200 orders is not uncommon
(i.e.; outstanding, unfilled at end of each day).  Exhibit l is a sample copy
of BC's order acknowledgement and invoice form. dBracketed fields represent
additional data only appearing on the invoice; the invoice guantity field denotes
the guantity actually shipped and billed for that invoice (which may be less than
that ordered due to stockouts or scrapped productidn).

Close to 30Z of all orders reguire multiple shipments; i.e., partial ship-
ments are freguent due to stockouts or customer wishes to receive all that is
available as soon as it is available. Any order or shipment may include multi-
ple line items (i.e., reguests for individual BC products). BC sells replace-
ment parts, components and complete control systems. Final (stock) inventory
of products is now maintained manually on bin cards (Exhibit 2 represents a
sample card).

BC's customers are often analyzed according to their location in a region
or territory. Many of BC's customers are agents or distributors; conseguently,
many shipping addresses may be associated with a single billing customer.  Fur-
ther, BC likes to keep track of customers which are divisions or subdivisions
of a parent (customer) firm. For example, several divisions of General Electric
are BC customers.

BC's products can be (price) discounted due to agreements with individual
customers. Because of freguent billing and shipping guestions, both complete-
ly shipped (called closed) orders and unfilled or partially shipped (called
open) orders must be readily accessible; the closed orders should be readily
accessible for one year after final shipment. BC freguently takes orders by
telephone, which typically reguires providing stock status information to the

customer.