Question
Draw the EER diagram for the following requirements: An instructor is defined by an ID (unique), name, office#, and mobile#. A student is defined by
Draw the EER diagram for the following requirements:
An instructor is defined by an ID (unique), name, office#, and mobile#.
A student is defined by an ID (unique), name, section#, and email.
A course is defined by a code (unique), name, and numberOfCredits.
A project is defined by an ID (unique), name, and start date.
An instructor may teach many courses.
A course must be taught by one or more instructors.
A student must take one or many courses.
A course must be taken by many students.
A course may be a pre-requisite for may courses.
A course may have many pre-requisites.
A student may participate in one project.
A project has to have one or more students participating in it.
A student has to be either a graduate student or an undergraduate student and cant be both.
Undergraduate students have a level and have to be supervised by one instructor only.
An instructor has to supervise one or more undergraduate students.
Graduate students have a thesis title.
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