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.