check the file for question

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 Draw the Network Chart – include task id, duration, ES, EF, LS, LF, slack What is the critical path? What is slack time for tasks F and G? 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? 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? What is slack time and lag time? Can the critical path of a project change? Why or why not?