Create the entity relationship diagram for hospital

Assignment Help Software Engineering

Reference no: EM1388240

Create the Entity Relationship Diagram(ERD) for following hospital scenario. For Patient entity illustrates its attributes. Highlight key attribute in red.

Patients are treated in single ward by doctors assigned to them. Generally each patient will be assigned single doctor, but in rare cases they will have two. Healthcare Assistants also attend to patients, number of these are associated with each ward. Initially the system will be concerned completely with drug treatment. Each patient is needed to take variety of drugs certain number of times per day and for varying lengths of time.

Reference no: EM1388240

Questions Cloud

Explain three physiological differences : Explain three physiological differences you would expect betweem two combat- navie soldiers placed on the front line in a war zone if one was given a potent phenylethanolamine

Advantages and disadvantages to speed treatment : Based upon the amount of time per appointment, how many appointments is your office scheduling a day? Critically discuss some advantages and disadvantages to speed treatment?

Assume the initial forecast for day : Your job is to compute forecasts using exponential smoothing technique with alpha of 0.3. Assume the initial forecast for day 1is 37. Show details for at least three calculations

Probability of being satisfactory : If she performs 15 demonstrations this week, what is the probability of her being satisfactory? What is the probability of between 4 and 8 (inclusive) orders?

Create the entity relationship diagram for hospital : Create the Entity Relationship Diagram(ERD) for following hospital scenario. For Patient entity illustrates its attributes. Highlight key attribute in red.

Attenuate the effect of dobutamine : Describe why dobutamine is sometimes given to patients to simulate the effect of exercise. What drug would you suggest a person take to attenuate the effect of dobutamine?

Discuss some of the aspects of the transfer of training : discuss some of the aspects of the transfer of training. What are the primary factors that play a role in the success of the process?

Description of quality improvement model : Mention for a possible procedure to conduct chart audits and description of quality improvement model to be followed and research and recommendations of associations that may want to be informed on healthcare quality standards in future.

How much interest have you paid the bank over that time : How much will you still owe at the end of 18 months. How much interest have you paid the bank over that time period. As for all assignments, answer the questions on the spreadsheet and attach the Excel spreadsheet file as your submission.

User Account

All Pages