hospital# = integer *** hospital insurance number ie AHC num. * Key attribute of object Patients in ERD and data flow in DFD. Must be exactly 9 digits long. op_date = integer * None key attribute of the object O/R-shifts; Made up of day, month and year in format ddmmyyyy. operation = O/R-schedule * Data flow in DFD corresponding to instance of the relationship "O/R-Schedules" op# = integer ***system generated - unique to each particualr operation * Key atttribute of object O/R-shifts in ERD and relationship O/R-schedules, data flow in DFD. Will be generated by the system. op_recovery-room = integer *** recov. room. num. to be used * None key attribute of the object O/R-shift and data flow in DFD; Made up of floor number and one of the 100 recovery rooms. op_room = integer *** room number * None key attribute of the object O/R-shift; Combination of floor number and one of the 20 operating rooms in the hospital. O/R-schedule = {O/R-schedules} * Data store in DFD corresponding to instance of the relationship "O/R-schedules". O/R-shedules = @op# + @staff# + @treatment# *** op# - system generated key - unique to the operation * Object, represents relationship between the object "O/R-Shifts", the object "Staff" and the weak entity "Treatments". This object represents the scheduling of Staff for each operating room booked for a treatment. O/R-info = {O/R-shifts} * Data store in DFD corresponding to instance of the relationship "O/R-shifts". O/R-shift = O/R-info * Data flow in DFD corresponding to instance of the relationship "O/R-shifts". O/R-shifts = @op# + O/R-shift-data * Object, represents the operating room facilities, the time schedule associated with it and the recovery room of which one recovery room is associated with each time slot. O/R-shift-data = op-room + op-date + op-start-time + op-stop-time + op-recovery-room * data input - part of object O/R-shifts O/R-start-time = integer * None key attribute of the object O/R-shifts and data flow in DFD. 24 hour military time, 4 digits long. O/R-stop-time = integer * None key attribute of the object O/R-shifts and data flow in DFD. 24 hour military time, 4 digits long. pa-address = string * None key attribute of the object Pateints and data flow in the DFD. Consists of house number, street, city, province, country. pa-first = string *** first name * None key attribute of the object Pateints and data flow in the DFD. First name and initials of patient if known. pa-last = string * None key attribute of the object Pateints and data flow in the DFD. Last Name of patient. pa-phone = integer * Non key attribute of the object Pateints and data flow in the DFD. Consists of 3 digit area code and 7 digit local number. patient = Patient-Info * Data flow in DFD corresponding to instance of the relationship "Patients" Patients = @hospital# + pa-first + pa-last + pa-phone + pa-address * Object, represents patients who are currently in the hospital, have previously been in the hospital or are on the hospital waiting list. Patient-Info = {Patients} * Data store in DFD corresponding to the object "Patients". sh_date = integer * None key attribute of the object Shifts; Made up of day, month and year in format ddmmyyyy. sh-start-time = integer * None key attribute of the object Shifts and data flow in DFD. 24 hour military time, 4 digits long. sh-end-time = integer * None key attribute of the object Shifts and data flow in DFD. 24 hour military time, 4 digits long. sh-title = string ***string - title of the person working the shift - MD, regular, super. * Same as st-title sh-ward = integer ***ward to serve shift in * None key attribute of the object Shifts in ERD and data flow in DFD. Must be between 1 and 8 and corresponds to a floor in the hospital. shift = Shift-Info * Data flow in DFD corresponding to object "Shifts". Shift_Info = {Shifts} * Data store in DFD corresponding to the object "Shifts". Shifts = @sh-ward + @sh-date + @sh-start-time + @sh-end-time + @sh-title * Object, corresponds to a specific period of time slot in a specific day for staff to be scheduled into. st-address = string ***staff address * None key attribute of the object Staff and data flow in the DFD. Consists of house number, street, city, province, country. st-first = string ***staff first name * None key attribute of the object Staff and data flow in the DFD. First name and initials of staff member if known. st-last = string * None key attribute of the object Staff and data flow in the DFD. Last Name of staff member. st-phone = integer * None key attribute of the object Staff and data flow in the DFD. Consists of 3 digit area code and 7 digit local number. st-specialty = integer ***ie cardiac, pediatrics, itc.... * None key attribute of the object Staff and data flow in the DFD. Single digit between 1 and 8 corresponds to a floor number in the hospital. st-title = string ***regular, supervisor, MD * None key attribute of object Staff and data flow in DFD. Three characters long indicates whether staff member is doctor, regular nurse, or supervisory nurse. staff = Staff-Info * Data flow in DFD corresponding to the object "Staff". Staff = @staff# + staff-data * Object, represents staff member currently employed at the hospital. staff-data = st-first + st-last + st-phone + st-address + st-title + st-speciality. * data input - part of object "Staff". staff_Info = {Staff} * Data store in DFD corresponding to the object "Staff". staff# = integer ***unique to a particular staff member * Key attribute of object Staff in ERD and data flow in DFD Should be exactly 9 digits in length. tr-admit = integer ***addmission date * None key attribute of the object Treatments in ERD and data flow on DFD. Date admited in format ddmmyyyy. tr-discharge = integer ***discharge date - expected * None key attribute of the object Treatments in ERD and data flow on DFD. Date discharged in format ddmmyyyy. tr-length = integer * None key attribute of the object Treatments in ERD and data flow on DFD. Indicates the projected length of stay for determining notification to people on waiting list. tr-priority = integer * None key attribute of the object Treatments in ERD and data flow on DFD. Priority on the waiting list. tr-record = string ***notes on treatment * None key attribute of the object Treatments in ERD and data flow on DFD. For Nurse or doctor forrecording specific note about treatment. tr-room = integer ***patients assigned room * None key attribute of the object Treatments in ERD and data flow on DFD. Four digit number; the first number indicates the floor. tr-ward = integer * None key attribute of the object Treatments in ERD and data flow on DFD. Must be between 1 and 8 ward corresponds to a floor in the hospital. treatment = Treatment-Info * Data flow in DFD corresponding to the object "Treatments". treatment-data = @hospital# + tr-admitt + tr-discharge + tr-ward + tr-length + tr-room + tr-priority + tr-record * data input - this is part of object "Treatments". treatment# = integer ***unique system generated number - particular to a patient and a specific treatment * key attribute of object in ERd and data flow in DFD. Generated by the system. Treatments = @treatment# + Treatment-data * Object, represents treatment that a patient may have had, is currently undergoing or is on the waiting list for. treatment-info ={Treatment} * Data store in DFD corresponding to the object "Treatments}. Work-schedules =@staff# + @sh-ward + @sh-date + @sh-start-time + @sh-end-time + @sh-title ***ward work schedule * Object, represents relationship between Staff and Shifts objects. Each staff is assigned a specific shift.