Could someone please assist with enhanced E-R Diagram given the following information:
A hospital is composed of 10 wards; each ward has up to 30 rooms.
Each ward is uniquely identified by a unique number (e.g. W1) and name (e.g.“Obstetrics”).
There are two main groups of stakeholders: hospital staff and patients.
Hospital staff is exhaustively divided into care (GPs, nurses, social carers) and administration (administrative staff).
Every hospital staff member is necessarily also a member in one of the subgroups.
Some carers do both social care and nursing.
The hospital provides two basic services to patients: treatments and
medication
GPs administer medicine and treat patients. Nurses do only administer
medication. Social cares only provide treatment.
Each treatment has a name and one of three priority levels: low, medium,
high. Medications have a dosage and times when they should be administered.
Each patient has a patient admittance number and name written on a wrist band and stays in a room. A room has up to ten beds, but a patient with private health insurance has their own room. The private health insurance number is recorded for all such patients. It is important to know which beds are free in cases of emergency (e.g., flu outbreak)
A patient’s address comprises house/unit number, street, city and postcode.
Could you create the database and entities, relational model. As having trouble understanding the concept.
No, I am sure we’re doing the same subject though. It’s a first year Uni IT course called Organizational Databases, the problem was we only had like an hour or two of class to explain the E-R concept/modeling before we moved on to other topics.
I spent a few hours yesterday working out a rough draft and checked with my lecturer that I was doing alright though so :tup:
I have a question about the Admin relation. Do we just leave it as “Admin” or something related to Hospital Staff? I’ve got “Admin” -> “Administrative staff”, but it looks rather stupid having it there.