Question: Consider the following information about a university database: Professors have a National Identity Number ( NIN ) , a name, an age, a rank,and a
Consider the following information about a university database: Professors have a National Identity Number NIN a name, an age, a rank,and a research specialty. Projects have a project number, a sponsor name eg TETFUND astarting date, an ending date, and a budget. Graduate students have an NIN, a name, an age, and a degree programeg MSor PhD Each project is managed by one professor known as the projectsprincipal investigator Each project is worked on by one or more professors known as theprojects coinvestigators Professors can manage andor work on multiple projects. Each project is worked on by one or more graduate students known asthe projects research assistants When graduate students work on a project, a professor must supervisetheir work on the project. Graduate students can work on multipleprojects, in which case they will have a potentially different supervisorfor each one. Departments have a department number, a department name, and a mainoffice. Departments have a professor known as the HOD who runs thedepartment. Professors work in one or more departments, and for each departmentthat they work in a time percentage is associated with their job. Graduate students have one major department in which they are workingon their degree. Each graduate student has another, more senior graduate studentknown as a student advisor who advises him or her on what courses totake draw an ER diagram that captures the information about theuniversity. Use only the basic ER model here; that is entities,relationships, and attributes. Be sure to indicate any key andparticipation constraints
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
