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

  1. 👍 0
  2. 👎 0
  3. 👁 929
  1. excuse me who can solving

    1. 👍 0
    2. 👎 0

Respond to this Question

First Name

Your Response

Similar Questions

  1. science

    Read the scenario and answer the following questions: a. How could the scenario have been prevented? b. How should the student respond in the scenario to minimize the harm? During an experiment, Carin carefully pours solution A

  2. history

    why is job specialization an important feature of civilization A. Job specialization creates social classes B. Job specialization allows for a variety of goods and services to be produced******* C. Job specialization allows the

  3. social studies

    Why is job specialization an important feature of civilization? A. Job specialization creates social classes. B. Job specialization allows for a variety of goods and services to be produced. C. Job specialization allows the

  4. Calculus

    A car starts from point P at time t=0 and travels at 45 mph. A)write an expression d(t) for the distance the car travels from p. (would it just be y=45x??) B)What is the slope of the graph? what does it have to do with the Car?

  1. Trigonometry

    A crow is on the ground 80 feet from the base of a 45 foot tall tree. It then flies straight throught the air to the top of the tree. What is the angle of the crow's flight path relative to the ground ?

  2. Algebra Question 1

    5. Business B pledged $20 million less than twice the amount pledged by Business A. Business C pledged $200 million less than twice the amount pledged by Business B. If x represents the amount pledged by the Business A, write

  3. 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

  4. Business

    2. Assignment: Evolution of Business Presentation • Resources: Ch. 2 of Introduction to Business • Create a 10- to 15-slide Microsoft® PowerPoint® presentation describing the evolution of business. • Include information

  1. COM 135

    Prewriting,writing, ReWriting are 3 main steps in the technical writing process. Read the following scenario: As a customer service manager for a local software development company, you want to create a user manual for one of the

  2. PSYCHOLOGY HELP PLEASE!!

    Todd said to his wife, "Honey, you know how we have always wanted to be in business for ourselves? Well, today I did it! I have rented a 3,000 square foot business, hired six employees, ordered office furniture; we are in

  3. math

    In the scaled down drawing of a sport utility vehicle shown below,1/4 of an inch represents 1/2 of a foot. What is the unit rate in inches per foot? A. 1/2 of an inch per foot B. 1/8 of an inch per foot C. 1/4 of an inch per foot

  4. 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

You can view more similar questions or ask a new question.