database management

posted by .

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. In addition, the patient’s name and date of birth are recorded. Some patients are resident patients who spend at least one night in the hospital, and others are outpatients who are treated and released. Resident patients are assigned 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. Each resident patient will stay in only one room. Every room must have had a patient, and every resident patient must have a room.

  • database management -

    excuse me who can solving

Respond to this Question

First Name
School Subject
Your Answer

Similar Questions

  1. math, pre- statistics

    Hospital records indicated that maternity patients stayed in the hospital for a number of days shown in the distribution Days Stayed Frequency 1 34 2 23 3 17 4 11 5 8 If a patient's records are selected calculate the probability of …
  2. 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?
  3. 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 …
  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. 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 …
  6. Information Systems

    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 …
  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. database

    ERD of _ A patient can make many appointments with one or more doctors in the clinic, and a doctor can accept appointments with many patients. However, each appointment is made with only one doctor and one patient. _ Emergency cases …
  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