Computer Programming and Analysis APC100 Lecture Notes - Lecture 9: General Surgery, Social Insurance Number, Lakeshore Hospital
23 Mar 2016
School
Department
Professor
Document Summary
Dbs301 assignment#2 -- due on thursday, march 24th by 2pm. Printout submission only -- final (resolved) erd with all attributes, pk, fk. The lakeshore hospital is a regional acute care facility. System about patients and their treatments by the medical staff. Central point of this is is info about patients (last name, first name, middle name, full address, date of birth, home phone number and social insurance number) who are identified by patientid. Each time a patient receives any treatment or attention from a member of the nursing or physician medical staff at the hospital, the entry is made into the patient s automated hospital record. This entry is actually a comment that may be up to 4000 characters long and it is recorded together with the date of this entry. When patients are admitted to the hospital they are assigned a specific bed and the hospital has various bed types to provide.
