Ask questions and get helpful answers.

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 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. 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. 👍
  2. 👎
  3. 👁
  4. ℹ️
  5. 🚩
1 answer
  1. What is your question?

    1. 👍
    2. 👎
    3. ℹ️
    4. 🚩

Answer this Question

Similar Questions

  1. 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? D)Create a scenario in which


    1. You've told Dan, a new contact, that you're looking for a qualified sales representative. Now you want to find out if there's any way you can help his business. What's an effective way to approach the question? A. Give him your business card and tell

  3. math

    You want to install kitchen floor tiles that each measure 12 inches by 12 inches (1 sq. foot). Your kitchen measures 12 feet by 14 feet, but there is a 2 foot by 4 foot area around the sink that will not be tiled. How many tiles do you need?

  4. Management

    A small home business is set up with an investment of Birr 1,000,000 for equipment. The business manufactures a product at a cost of Birr 60 per unit. If the product sells for Birr 140, how many units must be sold before the business breaks even?

  5. math

    3 friends A,B,C started a business investing rs 5000,10000,7500.A left the business after 6 months while C invested 5000 more after 6 months. A profit of 9000 earned at the end of the year.profit of C is ???

  6. programming

    create the logic for a program that calculates and displays the amount of money you would have if you invested $5000 at 2 percent simple interest for one year. create a separate method to do the calculation and return the result to be displayed.

  7. algebra

    You have fifty feet of fencing to use to create a new pen for your dog. Describe three differently-shaped pens you could create.

  8. physics

    When a person stands on tiptoe (a strenuous position), the position of the foot is as shown in Figure P8.16a. The total gravitational force on the body, Fg, is supported by the force n exerted by the floor on the toes of one foot. A mechanical model of the

  9. biology

    Evolution Versus Natural Selection Quick Check 1. Consider the following scenario: An animal is born with a shorter tail. This makes no difference to its ability to survive or reproduce, but as a result of pure luck, the animal survives, reproduces, and

  10. AP Physics - Equilibrium

    The Achilles tendon is attached to the rear of the foot as shown in the figure below. When a person elevates himself just barely off the floor on the ball of one foot, estimate the tension Ft in the Achilles tendon (pulling upward) and the (downward) force

Still need help?

You can ask a new question or browse existing questions.