Draw the associated E-R Diagram and signify which components need to be included to meet the defined needs.
1) The user is a director of research for a large foundation. Approximately three hundred facilities are staffed by the foundation’s twelve-hundred employees. Over seventeen hundred projects are currently underway, with some three-hundred and fifty waiting to be worked on in the future.
The system is responsible for information regarding the current state of affairs only. Requests for information are:
· List all current employees in name sequence
· List all employees who work at a particular facility
· Determine which facility has the most employees; which has the fewest
· Display the names of all employees currently working on a particular project
· Display all projects an employee is currently working on
· Locate inactive (no employee assigned) project
· Determine the ratio of active to inactive projects