check the file for question

Draw the two ERD diagrams (name them) for the following :

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.

Number each component (i.e. entities, relationships) in ERD 2 and identify which components are needed to report on the following (e.g. report 1 needs components 4, 5,7 to be produced):

List all current employees in name sequence
List all employees who work at a particular facility
Determine which facility has the most employees
Display the names of all employees working on a project
Display all the projects on which an employee is working
List inactive (no employee assigned) projects
Determine ratio of active to inactive projects ERD 1: ERD 2:

For the following tasks

Task	Duration	Predecessor	Successor	Constraints

				B overlaps A by 3 days
	12		D,G



				3 days take place between G
				ending and H beginning

		F,H

1. Draw the Network Chart – include task id, duration, ES, EF, LS, LF, slack
2. What is the critical path? What is slack time for tasks F and G?

1. Would the management of the project change if there was determined to be a new task H1 predecessor H successor I with duration 2? Why or Why not?
2. Would the management of the project change if there was determined to be a new task H1 predecessor H successor I with duration 5? Why or why not?
3. What is slack time and lag time?
4. Can the critical path of a project change? Why or why not?