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

  1. 👍 0
  2. 👎 0
  3. 👁 700
  1. I'm looking for the answer also.

    1. 👍 0
    2. 👎 0

Respond to this Question

First Name

Your Response

Similar Questions

  1. Pre-Calc

    A page that is x inches wide and y inches high contains 30 square inches of print. The top and bottom margins are 2 inches deep, and the margins on each side are 2 inches wide. a. draw a diagram that gives a visul representation

  2. Operating Systems

    Given that main memory is composed of only three page frames for public use and that a seven-page program (with Pages a, b, c, d, e, f, g) that requests pages in the following order: a, c, a, b, a, d, a, c, b, d, e, f. Using the

  3. Math

    A bookworm finds itself on page 1 of volume 1 and begins eating straight through to the last page of volume 5.If each book is 6 centimeters thick,including the front and back covers,which are half a centimeter each what is the

  4. technolgiy

    Lines are used in design to? Choose all that apply. 1:create movement 2:lead the eye across the page 3: describe the relationships between certain colors 4:divide a page into sections. Please help me this is my first time using

  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?

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

  3. Algebra

    Use the above graph of f(x) to complete the following table for values of its inverse function, f^{-1}(x). The graph has a point on (2,2)the y-intercept is 4 the x intercept is 3 x =-4, 8, 0, -2, 2 f^{-1}(x) Note: You can earn

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

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

  2. Calculus

    1) A rectangular page is to contain 16 square inches of print. The page has to have a 2-inch margin on top and at the bottom and a 2-inch margin on each side. Find the dimensions of the page that minimize the amount of paper used.

  3. math

    Hi. Please help me with this?: Suppose you start a home business typing technical research papers for college students. You must spend $3500 to replace your computer system. Then you estimate the cost of typing each page will be

  4. Economics

    Supply is Demand is Scenario A elastic elastic Scenario B elastic inelastic Scenario C inelastic elastic Scenario D inelastic inelastic Which scenario describes the market for oil in the long run? A. A B. B C. C D. D

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