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 (e.g., TETFUND), astarting date, an ending date, and a budget. Graduate students have an NIN, a name, an age, and a degree program(e.g., M.S.or Ph.D.). 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 co-investigators). Professors can manage and/or 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 student(known as a student advisor) who advises him or her on what courses totake.3. 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 blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!