Relationship Model for the hospital’s data model (Figure 1) in form of a diagram in Chen notation. Identify special attributes (including keys) in the diagram and include participation and cardinality constraint annotations for your relationships. List and explain any additional assumptions you think you have to make because the specification was unclear or incomplete. Note that there should not be many such extra assumptions. Marking Criteria The following criteria will be used to mark your
You have been asked to design part of a
hospital managers provided you with an informal description of their
data which you can find on the next page in Figure 1.
(a) Provide an Enhanced Entity-Relationship Model for the hospital’s data model (Figure 1) in form of a diagram in Chen notation. Identify special attributes (including keys) in the diagram
and include participation and cardinality constraint annotations
for your relationships.
List and explain any additional assumptions you think you have
to make because the specification was unclear or incomplete.
Note that there should not be many such extra assumptions.
Marking Criteria
The following criteria will be used to mark your model:
• extent to which your model is correct, minimal (no feature
modelled twice), complete and expressive
• correct use of Chen notation (including special attributes)
• correct cardinality and participation constraints (including
notation)
• readability and presentation of your answer. You can design
the diagram in any software system you like, as long as you
stick to the notation used in the lectures and embed it into
your submission. For scanned hand-written diagrams at least
10% points will be deducted depending on the appearance.
[44 marks]
(b) Document and explain your choice of cardinality and participation constraints from Question (a) (following the schema presented in lectures). Include references to the specification in Figure 1 to corroborate your decisions. Note that your answer must
be in agreement with the constraints you added to your EntityRelationship diagram in Question 1(a). [18 marks]
We employ doctors and we keep their first and last name, national insurance number, salary, date of birth, various phone numbers so we
can reach them at all times, a home address, and their special area of
expertise. An address consists of street, house number, name of town,
and postcode. We also keep track of the number of operations a doctor
has been involved in.
Our operating theatres are numbered. For each operation we store
the theatre number. Moreover, we record the type of the operation,
the date of the operation, the time the operation started and how long
it lasted. An operation is carried out by one or several doctors on a
single patient and we need to be able to later recall who operated on
whom. Operations are only put on record once we know who the doctors are and who the patient is. Each doctor involved in an operation
provides a short textual statement about how it went.
About a patient we keep the following information: their national insurance number, date of birth, first name and last name, gender, height,
weight, address, and medical records which are numbered sequentially
for each patient. An address consists of street, house number, name
of a town, and postcode.
A medical record consists of a date and time and a diagnosis (text).
Such a record must have been made by exactly one doctor. The medical records for a patient do not have to come all from the same doctor.
Patients can appear on our system before they have a medical record.
Some doctors (e.g. in training) may not be allowed to diagnose patients
(or operate on them) yet. Some doctors may have one mentor who is
also a doctor. Only a few senior doctors are mentors and each usually
has four or five tutees.
Step by step
Solved in 2 steps with 1 images
