Studierende stehen vor dem LC und blicken lächelnd einer Kollegin mit einer Mappe in der Hand nach.

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.