Carefully read following requirements and draw an ER diagram Professor is with the following attributes: SSN (unique), age and a name, rank and research
specialty.
Projects have a project number (unique), a sponsor (e. g. NSF), a starting date, ending date
and a budget.
Graduate students need to store information about the degree program (e. g. M. S. or Ph. D.)
that they are enrolled.
Each project is managed by one professor (known as the project's principal investigator).
A project must have a principal investigator.
Each project is worked on by one or more professors (known as co-investigators).
Professors can manage and/or work on multiple projects.
Each project is worked on by one or more graduate students (known as project's research
assistants).​