Question: [2]Please draw an ERD with all the attributes based on following: The company sells a number of different furniture products. And the identifier for a
[2]Please draw an ERD with all the attributes based on following:
The company sells a number of different furniture products. And the identifier for a product is Product_ID. Pine Valley Furniture has established a number of work centers. The identifier for a work center is Work_Center_ID. Another attribute is Location. 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. The identifier for employee is Employee_ID. Other attributes are Employee_Name, EmployeeAddress. An employee may have at least one skill. Each skill is possessed by many employees or none. And an employee has many skills in different expert levels. The identifier for the skill is the skill code. Each employee works in one or more work centers. A work center must have at least one employee working in that center. Each employee has exactly one supervisor except the top manager. An employee who is a supervisor may supervise any number of employees, but not all employees are supervisors.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
