Hospital and Appointment Management Purposes

Homework Assignment 2 03/04/13 Please bear your answer after each problem and submit the file with your answers by Angel. Problem 8 from page 145 Using the Crows Foot methodology, draw an ERD that can be implemented for a medical exam clinic, using at least the following business rules a. A diligent of can make many accommodations with one or more doctors in the clinic, and a doctor can accept duty assignments with many tolerants. However, each appointment is made with nevertheless one doctor and one long-suffering. b. Emergency cases do not require an appointment.However, for appointment management purposes, an emergency is entered in the appointment book as unscheduled. c. If kept, an appointment yields a visit with the doctor condition in the appointment. The visit yields a diagnosis and, when appropriate, treatment. d. With each visit, the patients records are updated to provide a medical history e. from each one patient visit creates a government note. Each patie nt visit is billed by one doctor, and each doctor can bill many patients. f. Each bill essential be paid. However, a bill may be paid in many installments, and a payment may encompass more than one bill. . A patient may pay the bill directly, or the bill may be the basis for a birdsong submitted to an insurance company. h. If the bill is paid by an insurance company, the deductible is submitted to the patient for payment. pic Problem 2 from page 173 Given the following business scenario, create a Crows Foot ERD using a specialty hierarchy if appropriate. Tiny Hospital keeps information on patients and hospital ways. The establishment assigns each patient a patient ID number. In addition, the patients name and date of birth are recorded.Some patients are resident patients (they throw at least one night in the hospital) and others are outpatients (they are treated and released). Resident patients are assigned to a populate. Each populate is identified by a room number. The sy stem also stores the room type (private or semiprivate), and room fee. Over time, each room give have many patients that stay in it. Each resident patient will stay in only one room. Every room must have had a patient, and every resident patient must have a room. I believe specialization hierarchy is degree centigrade percent not appropriate.Although resident patients are an identi? able type of patient sheath, there are not additional attributes that are unique to only that kind or type of patient. Participation in a race that is unique to a particular kind or type of instance is not suf? cient justi? cation for a specialization hierarchy. Indicating that only some instances will figure in a relationship is addressed by the ex gratia involvement designation. In this module, all resident patients must have a room however, not all patients are resident patients so room is optional to patient.