Draw a conceptual schema for the specification of a database domain listed above.
Read and analyse the following specification of a sample
A University would like to create a database to record information about some of its
activities.
The university offers a number of degrees to students. A degree is described by a unique
name, total number of credit points required to complete a degree, and several
requirements that must be satisfied by the future students. The university offers three
types of degrees: undergraduate degrees, postgraduate degrees, and graduate certificate.
Postgraduate degrees are available only for the students who already got an
undergraduate degree. A description of a postgraduate degree includes a list of
acceptable undergraduate degrees. A description of a graduate certificate includes a
requirement on the total number of years of professional experience.
Each degree consists of a collection of subjects. A description of a subject consists of its
unique code, unique title, total number of credits points a subject is worth, and a list of
subject learning objectives.
The university employs academic staff members, tutors and support staff members. A
description of a university employee consists of a unique employee number, first name last
name and date of birth. First name, last name and date of birth uniquely identified each
employee. Additionally, academic staff members and tutors are described by an academic
degree achieved. Support staff members are described by a list of qualifications acquired
in the past together with a date when each qualification has been acquired.
The university assigns the academic staff members and tutors to the subjects. A subject
has one or two academic members assigned and a number of tutors. An academic staff
member and tutor can be assigned to many subjects. Support staff members are assigned
to the degrees. Each support staff member is assigned to one degree and a degree has
one or more support staff members assigned.
The university is divided into faculties and faculties are divided into schools. Academic
staff members and tutors belong to one school and each school consists of many
academic staff members and tutors. The faculties and schools are described by the unique
names.
Draw a conceptual schema for the specification of a database domain listed above.
Step by step
Solved in 5 steps with 1 images
