Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Draw a class diagram based on the following requirements: All instructors consist of professor, associate professor, and assistant professor. Departments offer many courses, but a

Draw a class diagram based on the following requirements:
All instructors consist of professor, associate professor, and assistant
professor.
Departments offer many courses, but a course is offered by one or
more department.
Courses are taught by instructors, who may teach up to three
courses.
Instructors are assigned to one department.
One instructor may chair a department.
Extend the class diagram to include the following attributes:
A department includes the department ID (private), department name
(public), and description about the department (public)
An instructor includes the instructor ID (private), instructor name
(public) and department
A course includes the course ID (private), course name (public).
course description (public), and prerequisite course (protected)
Extend the class diagram to include the following operations:
Instructors can
Select course
Prepare course plan
image text in transcribed

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_2

Step: 3

blur-text-image_3

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

The Database Relational Model A Retrospective Review And Analysis

Authors: C. J. Date

1st Edition

0201612941, 978-0201612943

More Books

Students also viewed these Databases questions