pleas see the attached Document Preview: Create a Conceptual ER Diagram for the Mountain View Community Hospital case described at the end ofChapter 3 (pages XXXXXXXXXXYou can ignore the volunteer...

1 answer below »
pleas see the attached
Document Preview:

Create a Conceptual ER Diagram for the Mountain View Community Hospital case described at the end ofChapter 3 (pages XXXXXXXXXXYou can ignore the volunteer application form (Figure 1). The diagram shouldinclude all relevant entities, attributes and relationships. For each entity, specify the identifier (primary key).Specify relationship names and cardinality constraints. Indicate which attributes are required, composite, multivalued,and/or derived (Note: by default, an attribute is assumed to be optional, simple, single-valued and notderived). Indicate which entities are associative. Use consistent naming conventions for entities and attributes._ Use modeling/diagramming software to create the ER Diagram. Hand-written/drawn solutions will notbe graded._ Provide a cover sheet with your name and the name of the assignment._ If you made any assumptions, include them on the cover sheet. Note: the assumptions should bereasonable and should not contradict the facts of the case_ A soft copy of your completed assignment including the cover sheet (with assumptions, if any)

Answered Same DayDec 20, 2021

Solution

David answered on Dec 20 2021
3 Votes
Turgut Tezi
Turgut Tezi
TEZIR-1
CS 504.2354
Mountain View Community Hospital
Project Case 3
Project Question:
1. Why would Mountain View Community Hospital want to use entity-relationship modeling to understand its data requirements? What other ways might the hospital want to model its information requirements?
This hospital wants to use E-R modeling to understand data requirements. E-R modeling is very easy to understand and shows all the business rules.
· Entity-relationship modeling is logical representation of the data for an organization or for a business area. The E-R model is expressed in terms of entities in the business environment, the relationship among those entities, and attributes of both entities and their relationship. E-R model is normally expressed as entity-relationship diagram, which is graphical representation of the E-R model.
This Hospital also can use Object-Oriented model.
· (It is not recommended)Traditional File processing system, but there are lots of disadvantages with this using this system? Hospital can use information engineering, a top-down information systems planning approach.
2. Do there appear to be any weak entities in the description of the Mountain View Community Hospital data requirements? If so, what are they?
No weak entity. However, treatment can be a week entity.
· Treatement_ID
1. Threatment _Num
2. Threatment_Name
3. What is the significance in developing an E-R diagram for Mountain View Community Hospital to the third entry the preceding list, which states that some patients are assigned to a bed, but outpatient are not assigned to bed?
Some patient assigned to a bad, some of them don’t PATIENT has two subtypes
· In Patient (has relationship between Bed)
· Out Patient
4. Is Mountain View Community Hospital itself an entity type in a data model to represent its data requirements?
No. We don’t need to model Hospital entity type.
PROJECT EXERCISES
TEZIR-2
1. Study the project description very closely. What other questions would you like to ask in order to better understand the data requirements at Mountain View Community Hospital?
· Do we need to model the relationship with intern, volunteers and donors?
· Do all Hospital workers nurses, staff, physicians and etc. are subtypes of Employee?
· Do we need to record patient history?
2. Develop an E-R diagram for Mountain View Community Hospital. State any assumption you had to make in developing the diagram?
TEZIR-3
Bed
Primary Key
Bed_No [PK1]
Non-Key Attributes
Room_No
Center_No
Items
Primary Key
Item_No [PK1]
Non-Key Attributes
Description
Unit_Cost
Care_Cente
Primary Key
Center_No [PK1]
Non-Key Attributes
Center_Name
Physician
Primary Key
Physician_Id [PK1]
Non-Key Attributes
PhysicianIName
Employee
Primary Key
Emp_No [PK1]
Non-Key Attributes
Emp_Name
Patient
Primary Key
Patient_No [PK1]
Non-Key Attributes
Patient_Name
Treatment
Primary Key
Treatment_Id [PK1]
Has
assigned
assign
Perform
ca
y out
assign
use
Bed
Primary Key
Bed_No [PK1]
Non-Key Attributes
Room_No
Center_No
Items
Primary Key
Item_No [PK1]
Non-Key Attributes
Description
Unit_Cost
Care_Cente
Primary Key
Center_No [PK1]
Non-Key...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here