Information Systems

posted by .

Problem #2 from page 173
Given the following business scenario, create a Crow’s Foot ERD using a specialization hierarchy if appropriate. Tiny Hospital keeps information on patients and hospital rooms. The system assigns each patient a patient ID number. In addition, the patient’s name and date of birth are recorded. Some patients are resident patients (they spend at least one night in the hospital) and others are outpatients (they are treated and released). Resident patients are assigned to a room. Each room is identified by a room number. The system also stores the room type (private or semiprivate), and room fee. Over time, each room will 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.

  • Information Systems -

    I'm looking for the answer also.

Respond to this Question

First Name
School Subject
Your Answer

Similar Questions

  1. Medical Information Management

    The original medical record is the property of the A. physician B. patient's attorney C. patient D. hospital or facility my answer is D. hospital or facility please, am i right?
  2. health

    Although hospital inpatient records have traditionally served as the documentation source and business record for patient care information. a.all patient records contain similar content and format features. b.alternate care facility …
  3. health

    The hospital inpatient record documents the care and treatment received by a patient admitted to the hospital. Where is the paper-based record stored while the patient is in the hospital?
  4. Pysichal Therapy Aide

    A PTA CAN ASK A SW TO HELP WITH ALL OF THE FOLLOWING EXCEPT: A. TO ASSES THE PATIENT'S HOME ENVIRONMENT AND INSTRUCT THE PATIENT AT DISCHARGE FROM THE HOSPITAL B. TO ARRANGE FOR HOME HEALTH SERVICES AT THE PATIENT DISCHARGED FROM THE …
  5. database management

    2. Given the following business scenario, create a Crow’s Foot ERD using a specialization hierarchy if appropriate. Tiny Hospital keeps information on patients and hospital rooms. The system assigns each patient a patient ID number. …
  6. computer science

    Using the Crow’s Foot notation, create an ERD that can be implemented for a medical clinic, using the following business rules:  A patient can make many appointments with one or more doctors in the clinic, and a doctor can accept …
  7. business

    New Orleans’s Mt. Sinai Hospital is a large, private, 600-bed facility complete with laboratories, operating rooms, and X-ray equipment. In seeking to increase revenues, Mt.Sinai’s administration has decided to make a 90-bedadditiononaportionofadjacent …
  8. data

    Given the following business scenario, create a Crow’s Foot ERD using a specialization hierarchy if appropriate. Tiny Hospital keeps information on patients and hospital rooms. The system assigns each patient a patient ID number. …
  9. Medical Billing

    You're a coder who's reviewing the record of a 62-year-old woman who was admitted to the hospital with shortness of breath and minor chest pain. The doctor diagnosed the patient with Staphylococcus aureus pneumonia and you assigned …
  10. Physics

    Hospital patient. A 90.0 kg patient is suspended in a raised hospital bed as shown in the figure. The wire is attached to a brace on the patient's neck and pulls parallel to the bed, and the coefficients of kinetic and static friction …

More Similar Questions