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

Exercise No. 5: Material and Supplier

Transfer the following verbal description into an ERM

a) Items (Item-#) belong to a category (Cat-ID). An (Item) category can be assigned to only one item. There is a hierarchical classification system of item categories. Each item category is assigned exactly to one category hierarchy.

b) Items have a unit of measure (UOM-ID). An item is uniquely assigned to a UOM.

c) A specific item is supplied by more than one vendor (Vendor-#) only. Vendors supply several items.

Solution (Part 1)

Exercise List