Reference no: EM132218511
Data Management and Security
Tasks
Read the following specification of a sample database domain.
A university would like to create a database that contains information about the subjects, students, enrolments, lecturers, and teaching duties of lecturers.
A student is described by a student number, first name, last name, date of birth, email address, contact phone number, and degree enrolled. A student number identifies each student.
Students have unique email addresses and unique phone numbers. We assume that no two students have identical combinations of the values of attributes for first name, last name and date of birth.
The subjects offered by the university are described by a unique subject number, unique title, total amount of credit points granted upon successful completion of a subject, and a short description. A subject is offered for enrolment once per year, in either Autumn or Spring session. Students enrol in subjects.
A student is allowed to enrol, drop, and to enrol again a subject many times. A database should contain information about all enrolments and all drops performed by the students. An enrolment of a subject and drop from a subject are described by an exact date and time when it has happened. The lecturers teach the subjects.
A lecturer is described by a first name, last name, a unique staff number, position occupied, title, and school they belongs to. The database should contain information about a session and year a lecturer taught a subject.
The running subjects have lecture classes. A database should contain information about the locations (building and room number), day, time and length of the lecture classes.
Your task is to create a conceptual schema of the sample database domain given above and to draw such schema in a notation of UML simplified classes of objects explained to you during the lecture.
No other notation will be accepted! To create a conceptual schema use a methodology explained to you in a presentation 04 Conceptual Modeling.
First, read through the specification listed above and find all classes of objects.
Next, read through the specification again and find all attributes. Next, read through the specification again and find all associations, link attributes, and association classes. Next, read through the specification again and find identifiers and qualifications.
Finally, read through the specification and find generalizations. Entire process described above must be included in the outcomes from the implementation of this task.