(Solved): Use Crow's foot method to draw an ER diagram to accurately represent these requirements set. Show p ...

Use Crow's foot method to draw an ER diagram to accurately represent these requirements set. Show primary key and cardinality. - Avenue Company sells a number of different furniture products. These products are grouped into several product lines. Attributes of product include Product_ID and Product_Description. - A product line may group any number of products, but must group at least one product. - Each product must belong to exactly one product line. - Customers submit orders for products. Attributes of order include Order_ID and Order_Date. - A customer may submit any number of orders but need not submit any orders. Each order is submitted by exactly one customer. Attributes of customer include Customer_ID, and Customer_Name. - A given customer order must request at least one product and only one product per order. Any product sold by Avenue Company may not appear on any order or may appear on one or more order. - The company has established sales territories for its customers. Each customer does business in one or more of these sales territories. - A sales territory may have any number of customers or may not have any customers doing business. - The company has several salespersons. A salesperson serves exactly one sales territory. - Each sales territory is served by one or more salespersons. - Each product is assembled from one or more raw materials. Attributes of raw material include Material_ID, Unit_of_Measure and Unit_Price. - Each raw material may be assembled into one or more products. - Raw materials are supplied by vendors. Attributes of vendor include Vendor_ID and Vendor_Name. - Each raw material can be supplied by one or more vendors. A vendor may supply any number of raw materials or may not supply any raw materials to the company. - An attribute of the relationship between vendor and raw material is Unit_Price. - The company has established a number of work centers. Each product is produced in one or more work centers. A work center may be used to produce any number of products or may not be used to produce any products. - The company has over 100 employees. Attributes of employee include Employee_ID, Employee_Name and Skill. An employee may have more than one skill. Each employee works in one or more work centers. A work center must have at least one employee working in that centre, but may have any number of employees. - Each employee has exactly one supervisor. An employee who is a supervisor may supervise any number of employees, but not all employees are supervisors.