Create high-level e-r diagram for hospital

Assignment Help Software Engineering
Reference no: EM1369988

After completing a course in database management, you have been hired as a data analyst by Abdel-Nasser Hospital. Your first assignment is to work as part of a team of three persons to develop a high-level E-R diagram for the hospital. You conduct interviews with a number of hospital administrators and staff to identify the key entities for the hospital. After a short time your team has identified the following entities:

·Ward a treatment center within the hospital. Examples of wards are maternity and emergency care. Each ward has a ward number (identifier) and a ward name.
· Patient a person who is either admitted to the hospital or is registered in an outpatient program. Each patient has a patient number (identifier) and name.
· Physician a member of the hospital medical staff who may admit patients to the hospital and who may administer medical treatments. Each physician has a physician ID (identifier) and name.
·Bed a hospital bed that may be assigned to a patient who is admitted to the hospital. Each bed has a bed number (identifier), a room number, and a ward number.
· Item any medical or surgical item that may be used in treating a patient. Each item has an item number (identifier), description, and unit cost.
· Employee any person employed as part of the hospital staff. Each employee has an employee number and name.
· Treatment any test or procedure performed by a physician on behalf of a patient. Each treatment has a treatment ID that consists of two parts:
treatment number, and treatment name.
The team next recorded the following information concerning relationships:

1. Each hospital employee is assigned to work in one or more wards. Each ward has at least one employee. and may have any number of employees. Th hospital records the number of hours per week t a given employee works in a particular ward.
2. Each ward has exactly one employee who is designated nurse in charge for that ward.
3. A given patient may or may not be assigned to a bed (since some patients are outpatients). Abed may or may not be assigned to a patient.

Reference no: EM1369988

Questions Cloud

Community at large benefit organization operationally : How does the concept of incorporating the opinion of the work community and community at large benefit the organization operationally?
Employment equilibrium level : Suppose that in 2012, the following prevails in the Republic of Askil; Suppose that households consume 75% of their income and save 25% of their income.
Use shared mutex for synchronization and locking mechanism : Execute two programs of matrix multiplication with thread programming. Use the shared mutex for synchronization and locking mechanism.
Keynesian consumption function : Show analytically and show graphically that, in Keynesian consumption function, the average propensity of consumption is always bigger that marginal propensity
Create high-level e-r diagram for hospital : Your first assignment is to work as part of the team of three persons to create high-level E-R diagram for hospital. You conduct interviews with number of hospital administrators and staff to recognize key entities.
Explain what should the carters cover in program : Explain what should the Carters cover in their new employee induction program and how should they covey this information?
Question about open economy multiplier : In a closed economy, marginal propensity to consume .6. If the economy opens up to world and marginal propensity to import is .4, using the Keynesian model of output determination;
Questions on opportunity cost : Economists make decisions by thinking in terms of alternatives. Why do economists thinks there is no such thing as a free lunch?
Create application which simulates functionality of gas pump : Create application which simulates functionality of gas pump. The user enters number of gallons to buy and clicks desired grade.

Reviews

Write a Review

 

Software Engineering Questions & Answers

  Draw flowchart-write pseudocode to represent logic

Draw a flowchart or write pseudocode to represent the logic of a program that allows the user to enter three values.

  Develop a dtd for catalog of cars

Develop a DTD for a catalog of cars, where each car has child elements make, model, year, color, engine, number_of_doors, transmission_type, and accessories.

  Create a complete limited entry decision table

Create a complete limited entry decision table

  Draw erd to track work orders and tasks of work orders

Draw an ERD. The database should track work orders and tasks of work orders. The following detailed information requirements should be represented by the ERD.

  Drawing flowchart to accept two number

Draw a flowchart to accept two number and any one of the follwing characters: +,-,*, and / . based on the character entered, the number should be added.

  Dialog diagram for web-based system for airline

Describe each section of the dialogue box. Imagine, you are developing a web-based system for an airline. Sketch the dialog diagram for some sample screens that users will need to navigate through.

  Create visual logic flow chart-calculate pay of employees

The user will then be able to continue calculating the pay for additional employees until the user decides to stop or until the maximum number of employees is reached. Create a Visual Logic Flow Chart.

  Create single conceptual erd showing entity-s primary key

Create single Conceptual ERD (on a single slide) for entire Case Study showing all attributes and identifying each entity's primary key.

  Draw entity-relationship diagram for heg

Instructors are capable of teaching many different courses. Draw an entity-relationship diagram for HEG (in 3NF).

  Designing e-r diagram for each product at pvf

Suppose that at PVF, each product. Design E-R diagram for this situation and state minimum and maximum cardinalities on the diagram.

  Describing rfid systems used in inventory control

Illustrate how are RFID systems used in inventory control and supply chain management? What kinds of relationships are possible in relational database?

  Explain how firm testing for each development method

Research, write, and provide a 4-6 page proposal of the alternative methods the firm might consider for completing the Frequent Shopper Program. Explain how the firm would conduct testing for each development method.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd