ABC Incorporated is a manufacturing company that has several plants in the northeastern part of the United States. These plants are responsible for leading different projects that a company might undertake, depending on a plants function. A certain plant might even be associated with several projects but a project is always under the control of just one plant. Some plants do not undertake any projects at all.

A plant could employ many employees but each employee can only work in one plant. Every plant is manager by an employee who works in the same plant. Not every employee is a plant manager nor can an employee manage more than one plant. Some employees are assigned to work on projects and in some cases might even be assigned to work on several projects simultaneously. For a project to exist, it must have at least one employee assigned to it. A project needs several employees depending on its size and scale.

Employees are supervised by some other employees in the same company. An employee may be a supervisor of several employees, but no more than 20.

ABC Incorporated sponsors recreational opportunities for the dependents of employees in order to nurture the hobbies of the dependents. Dependents need not have a hobby, but it is possible that some dependents may have several hobbies. Because some hobbies are not as popular as others, not every hobby needs to have participants.

Draw an ER diagram for this application (Assign at least two attributes including one unique identifier to each entity. If you believe that you need to make additional assumptions, clearly state them for each situation).