Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Professional Visual Basic 6 Databases

Authors: Charles Williams

1st Edition

1861002025, 978-1861002020

More Books

Students also viewed these Databases questions