Question
Draw a UML diagram for a database recording information about courses of the univer- sity, their teachers and exercise groups. Mark the key attributes and
-
Draw a UML diagram for a database recording information about courses of the univer- sity, their teachers and exercise groups. Mark the key attributes and use the notation used in the lectures and in the text book. The database should contain the following information:
-
For each course: its course code (unique), name, and the number of the credits.
-
For each time the course is arranged: the semester (like Spring 2020), starting and ending
dates, the responsible teacher(s) at this time, the exercise groups at this time.
-
For each exercise group: its ID (unique), name, weekday, starting time, finishing time, teacher, class room, and maximum number of the students in this group.
-
For each teacher: a unique ID, name, birth date, and title (like professor, lecturer or teaching assistant)
Make the following assumptions:
-
Each course may be arranged at most once during a certain semester. The number of exercise groups at different semesters may vary.
-
The number of the credits of a certain course does not vary.
-
The course may have several responsible teachers during the same semester and a certain
teacher may be a resonsible teacher in several courses.
-
A certain exercise group can have at most one teacher.
-
A certain exercise group meets once a week during the course, always at the same time at the same room.
The UML diagram is not supposed to contain any other information than mentioned above (like information about students, enrollments, grades, room reservations etc.)
-
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