Question: Entity Relationship Diagram 3
? Professors have a Phone number, a name, an age, a grade and a research specialty. ? Projects have a project number , a sponsor name (e,g IRPA) a starting date, an ending date, and a budget. ? Students have a roll no, a name, an age, and a degree program(e.g BS, MSC). ? Each professor must to work on multiple projects. ? Each project is worked on by one or more students. ? When students work on a project, multiple projects are acceptable, in which case they will have a supervisor for each projects. ? Departments have a department number, a department name, and a main office. ? Departments have a professor (known as the chairman) who must run the departments.