Question
Each faculty member has an identification number, a name, research specialty, an age, and a grade. o Research projects are granted in NUML. Research projects
Each faculty member has an identification number, a name, research specialty, an age, and a grade. o Research projects are granted in NUML. Research projects have a project id, sponsoring organization, a starting date, an ending date and an associated budget. o Each student has an identification number, a name, an age, and a degree program (e.g. BS, MCS, MS or Ph.D.) o Each project is managed by one faculty member, known as Principal Investigator. o Each project is worked on by one or more faculty members, known as projects co-investigators. o Faculty members can manage and/or work on multiple projects. o Each project is worked on by one or more students. o When students work on a project, a faculty member must supervise their work on project. Students can work on multiple projects, in which case they will have a (potentially different) supervisor for each project. o Departments have a department number, department name, and main office. o Departments have a faculty member, known as Dean, who runs the department. o Faculty members work in one or more departments, and for each department that they work in, a time percentage is associated with their job. o Students have one major department in which they are working on their degree. o Each student has an advisor, who advises him on what courses to take. The advisor himself is a senior student. Design and draw an EERD model for the given scenario.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started