Exercise No. 6: Web Shop
Transfer the following verbal description into an ERM
a) A supplier (Supp-#) processes many purchase orders (PO-#) and sells a number of products (Prod-#). A product is sold by only one supplier.
b) Each of the purchase orders that a supplier may process includes several products. The relationship between order and product is defined as "Line Item".
c) A customer (Cust-#) may place one or more purchase orders. A purchase order may be placed by only one customer.