Drawing crow-s foot erd using a specialization hierarchy

Assignment Help Basic Computer Science

Reference no: EM1344285

Q1) 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 who 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.

Reference no: EM1344285

Questions Cloud

Strategic financial tool-bankruptcy : Write down the ethical implications of corporations such as United Airlines and General Motors which utilize bankruptcy as a strategic financial tool to minimize their pension and health benefit obligations?

Question-business law and management ethics : Why should the definition of law emphasize enforcement? To what three factors do courts look for evidence of implied partnership?

Question based on u.s. economy : During times of financial crisis and economic downturn, recommend best course of action the Federal Reserve can take to minimize the negative impact to the United State economy.

Illustrate what are the factors which involve demand : Illustrate what are the factors which involve the provide also demand of which good or service. How do you expect the demand also provide of which good or service to change in the next yr.

Drawing crow-s foot erd using a specialization hierarchy : Given the following business scenario, create a Crow's Foot ERD using a specialization hierarchy if appropriate.

Bankruptcy-employee claims : Sonia, a book dealer, has following assets: a building worth $155,000, accounts receivable amounting to $32,500 due within the next three months, and $25,000 cash in the bank.

Determining leadership behavior and motivation : What are your thoughts on bankruptcy for small businesses - both good and bad? What are your perspectives of both the business owner and the creditor?

Public peering and private peering in net neutrality : What is the difference between "public peering" and "private peering"?

Explain exactly how you would take advantage : explain exactly how you would take advantage of this situation to create a riskless profit.

User Account

All Pages