This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: In-class Problem-3As a large service organization, Parkland Community Hospital depends on a large number of persons for its continued success. There are four groups of persons on whom the hospital is most dependent: employees, physicians, patients, and volunteers. Of course some common attributes are shared by all of these persons: Person_ID (identifier), Name, Address, Ciy/State/Zip, Birth_Date, and Phone.Each of the four groups of persons has at least one unique attribute of its own. Employees have a Date_Hired, Volunteers have a Skill, Physicians have a Specialty and a Pager# (pager number), and Patients have a Contact_Date (date of first contact with the hospital).Some other persons in the hospital community do not belong to one of these four groups (their numbers are relatively small). However, a particular person may belong to two (or more) of these groups at a given time (for example, Patient and Volunteer).Each patient has one (and one only) physician responsible for that patient. A given physician may not be responsible for a patient at a given time or may be responsible for one or more patients. Patients are divided into two groups: resident and outpatient. Each resident patient has a Date_Admitted attribute. Each outpatient is outpatient....
View Full Document
- Spring '11
- Entity-relationship model, care center, Parkland Community Hospital