ONLINE ORDER INFORMATION SYSTEM
A common business document is and order form. Orders are an integral part of any sales data base. In this exercise we will build an ER Diagram to represent the entities, attributes and relationships of a common order.
Consider the following sample order
Sample order form
ORDER NUMBER: __0500260____ DATE 01/24/2015
FROM: Acme Manufacturing Cust ID: A231
240 Broward Boulevard
Yuma, Arizona 89026
C/o Wiley Coyote
SHIP TO:
ITEM # QTY Cat. # DESCR. UNIT PRICE
1 16 135608 Canon Balls $ 54.99
2 100 982345 dynamite sticks $ 5.89
3 1 359265 Road Runner trap $249.99
Total Price $1718.83
In this sample we can see that there is;
1. Information about the order
2. Information about the customer
3. Information about the items ordered.
Exercise:
1. List the entities and their attributes.
2. List any relationships that may exit. Name the entities and the relationship
3. Assign cardinality to each relationship.
4. Draw the ER diagram.