Entity-Relationship Diagram

      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