### Generating the crow’s foot erd

Assignment Help Computer Engineering
##### Reference no: EM1315640

1) Provided the following business scenario, generate a Crow’s Foot ERD utilizing a specialization hierarchy if suitable.

Tiny Hospital keeps the information on patients and the hospital rooms. The system allocates each patient a patient ID number. Additionally, the patient’s name and date of birth are stored. Some patients are resident patients (they spend at least one night in hospital) and others are outpatients (they are treated and released). Resident patients are allocated a room. Every room is recognized by a room number. The system also records the room type (private or semiprivate), and room fee. Over time, every room will have several patients that stay in it. Every resident patient will stay in only one room. Each room should have had a patient, and each resident patient should have a room.

Note that within this scenario, a specialization hierarchy is not suitable. While resident patients are an recognizable kind or type of the patient instance, there are not additional attributes which are unique to only that kind or type of the patient. Participation in a relationship which is unique to a particular kind or type of the instance is not suf?cient. Provide justi?cation for a specialization hierarchy. Indicating that only some instances will participate in the relationship is addressed by the optional participation designation. In this scenario, all the resident patients should have a room; however, not all the patients are resident patients so ROOM is optional to patient. If students ask regarding the need for an attribute to distinguish between the outpatients and resident patients, remind them that in this limited scenario the only distinction between the outpatients and resident patients is whether or not they are linked with a room. Thus, they may consider the Room_Num foreign key in PATIENT table may serve in that capacity.

#### Questions Cloud

 Determine expected dividend yield and capital gain : Determine expected dividend yield and Capital Gain - Find the expected dividend yield and capital gain yield once Fast Start Inc.'s period of supernormal growth ends. Computing confidence interval for a confidence level : Assuming the sample size of 40 can be considered as large, compute the confidence interval for a confidence level of 90%. Computing quantity demanded by cross-product elasticity : Use the above data to answer the following questions-If the price of entertainment increases by 2 percent, what will happen to the quantity of food demanded? Please be specific Determine the preferred stock price : What is the preferred stock price if the required rate of return is 11% and what could be the maximum payment to the preferred stockholders on a per share basis? Generating the crow’s foot erd : Provided the following business scenario, generate a Crow’s Foot ERD utilizing a specialization hierarchy if suitable. Tiny Hospital keeps the information on patients and the hospital rooms. Confidence interval for a confidence level : We assume that the population is approximately normally distributed.  Find the confidence interval: for a confidence level of 95%: Prepare in good form a balance sheet : Preparation of Balance Sheet - Prepare in good form a balance sheet as of February 28, 2001. Determining standard deviation in average revenue : Suppose that sales of lemon­ade and sales of brownies are independent, determine standard deviation in his revenue. Effectiveness of demand side policy : Discuss the upshot of this policy in terms of a new equilibrium. Is this policy likely to have a negative repercussion on the crime rate? Can you come up with an idea concerning a major drawback of this policy?

### Write a Review

#### Mathematics in computing

Binary search tree, and postorder and preorder traversal Determine the shortest path in Graph

#### Ict governance

ICT is defined as the term of Information and communication technologies, it is diverse set of technical tools and resources used by the government agencies to communicate and produce, circulate, store, and manage all information.

#### Implementation of memory management

Assignment covers the following eight topics and explore the implementation of memory management, processes and threads.

#### Realize business and organizational data storage

Realize business and organizational data storage and fast access times are much more important than they have ever been. Compare and contrast magnetic tapes, magnetic disks, optical discs

#### What is the protocol overhead

What are the advantages of using a compiled language over an interpreted one? Under what circumstances would you select to use an interpreted language?

#### Implementation of memory management

Paper describes about memory management. How memory is used in executing programs and its critical support for applications.

#### Define open and closed loop control systems

Define open and closed loop cotrol systems.Explain difference between time varying and time invariant control system wth suitable example.

#### Prepare a proposal to deploy windows server

Prepare a proposal to deploy Windows Server onto an existing network based on the provided scenario.

#### Security policy document project

Analyze security requirements and develop a security policy

#### Write a procedure that produces independent stack objects

Write a procedure (make-stack) that produces independent stack objects, using a message-passing style, e.g.

#### Define a suitable functional unit

Define a suitable functional unit for a comparative study between two different types of paint.

#### Calculate yield to maturity and bond prices

Calculate yield to maturity (YTM) and bond prices