Identify Entities And Mapping Cardinalities Between Them 1 Hierarchical Organization Structure A A Group Group Id H 1 (74.19 KiB) Viewed 27 times
Identify Entities And Mapping Cardinalities Between Them 1 Hierarchical Organization Structure A A Group Group Id H 2 (74.19 KiB) Viewed 27 times
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-#).
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!