Question

Design ER diagram to capture the information below and explain fully your answer: The University has to create a database. In design stage the committee formed the following description:

“The research activity at the University is organized as series of projects:

Each project has project number, budget, funding organization, staring date and completion date.

Each project has a PI who is full time faculty at the university.

Each project has only one PI, but can have one or more Co-PI which are also faculty at the University.

Each faculty have a rank, age, name, specialty and SSN.

Each project is worked out by research assistants.

Each assistant has SSN, name, age and is working toward degree PhD or MSc.

The graduate assistants can work on many projects.

The work of graduate assistants is supervised by the faculty either PI or Co-PI.

Each faculty belongs to one or more departments in some ratio (i.e. 30% English and 70% anthropology for professor X)

Each department has name, and number of main office and Is led by chair who is also a faculty.

Research assistants belong to only one department.

Each research assistant has senior research assistant who advises him which courses to take.”

Answer 1