Discuss the following a strong entity type vs weak

This preview shows page 5 - 7 out of 12 pages.

2.Discuss the following:
Tutorial 2 Activities: Suggested SolutionsNew Oriental Hospital Case Study (10 Minutes)New Oriental Hospital (NOH) is a small private hospital run by a team of medical professionals in a localsuburb. According to hospital policy, each patient has to fill in a patient registration form (shown in Figure 1) onhis/her first visit. On the patient registration form each patient is uniquely identified using patient ID, and theform records registration date, patient’s personal details and insurance company details. Each patient mustnominate an insurance company, which will pay the account directly to the hospital after the patient isdischarged. NOH uses a separate system to manage payment processing. Information recorded on theregistration form may be updated at any time without the need to fill in another registration form. Tutorial 2- Page 5 of 12
31271NEW ORIENTAL HOSPITAL PATIENT REGISTRATION FORMPatient ID: p0122Registration Date: 11/01/00First Name: SallyLast Name: RobinsonAge: 72Gender: FemaleDate of Birth: 13/04/33Address: 5, Doodle Street, Alexandria, NSW, 2015Phone:9136 2801Insurance Company (ID): AU-51Company Name: Allianz AustraliaCompany Address: GPO Box 135, Sydney, NSW 2001.Company Phone: 9516 6978Company Representative: Nikki RonFigure 1: Patient Registration FormTask 1 (15Minutes + 5 minutes discussion)1.Draw an ERD for the above patient registration scenario and the information captured during this process, asdepicted in Figure 1.2.Document all relevant business rules.
a)Each patient has to fill in a patient registration form on his/her first visit.b)NOH uses a separate system to manage payment processing. c)Each patient must nominate an insurance company.d)Insurance company will pay the account directly to the hospital after the patient is discharged.e)Information recorded on the registration form may be updated at any time without the need to fill inanother registration form. nominatesPatientPatIdPatFNamePatLNamePatDOBPatAgePatGenderPatAddressPatPhonePatRegDateCompanyCompIdCompNameCompAddressCompPhCompRepA new patient medical chart form (shown in Figure 2) is completed by hospital staff for each patient visit, and isnumbered using the patient chart number. A staff nurse is responsible for recording patient’s symptoms on themedical chart before the patient is diagnosed by a doctor. A doctor is responsible for recording the diagnosis andTutorial 2- Page 6 of 12

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture