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

This question has been answered.

Get Answer