Represent the following scenarios with E-R diagrams drawn using the ER Assistant software. The diagrams should indicate cardinality and optionality of relationships. (Note: relevant attributes are indicated in capitals). Document all relevant business rules. Do not include business rules that are implicit in the E-R diagram.
1. Customers (CUSTNO, CUSTNAME, CUSTADDR) identified by CUSTNO order products identified by product number (PRODNO). Each order (ORDERNO, ORDERDATE) identified by ORDERNO can be for one or more products. Orders have one or more order lines. Quantity (QTY) and the price (PRICE) of each ordered product is recorded on the order lines. Products are stored in a warehouse. The location of products is identified by the combination of ROW, AISLE, and BIN.
Only one product is stored in each location. The description (DESCRIPTION), standard price (STDPRICE), and quantity (QTYSTORE) is recorded for each product.