Answer Happy

Identify entities and mapping cardinalities between them. 1. Hierarchical Organization Structure a) A group (Group-ID) has several companies (Comp-ID), whereas a company belongs to one group. c) Each company has several plants (Plant-ID); a plant belongs to one company only. d) A plant produces many items (Item-#). An item is only produced in one of the plants. 2. Person in Organization a) A person (P-ID) is either an employee or a manager. b) Persons work for one or more companies (C-ID). Companies usually employ at least one person. c) A manager manages one department (Dept-ID), which is assigned to one company, while companies have several departments. 3. Customer Discounts a) Customers (Cust-#) get discounts (Disc-#) on items (item-#). Each item can only have one discount rate. b) Items belong to a single category (Categ-ID) 4. Sales Department a) A sales department (SDept-#) is uniquely assigned to a customer characteristic (Cust-#), an article characteristics (Art-#) and a sales channel (Sch-#).