n. If an attribute is not readily apparent from the user information, then make one up that makes sense for the particular entity. Therefore, all entities should end up with at least an identifier and another attribute that makes sense. Please use a drawing tool of some type to show the ERD diagram (Word, PowerPoint, and Visio all work well). I want you to get in the habit of drawing these with a computer instead of by hand, as this will be important as we get to more difficult examples. You may us
San Diego Hospital Example ERD Problem
Entity Relationship Diagramming is a "top down" user process. Take the following user provided information and draw the appropriate ERD.
Follow the Simple Procedure for ERD diagramming to design an ERD using the following user provided information. Remember the ERD will eventually turn into the design for a
Please use a drawing tool of some type to show the ERD diagram (Word, PowerPoint, and Visio all work well). I want you to get in the habit of drawing these with a computer instead of by hand, as this will be important as we get to more difficult examples. You may use either the ER-Model or Crow's foot model, though answers will be provided in the Crow's foot by the instructor. Make sure you show entities, relationships, cardinality, and optionality.
San Diego Hospital Example
San Diego Hospital needs a database to help track information. Here are some general business rules regarding San Diego Hospital. Patients are always treated in a single ward, though the hospital is divided into 18 wards. Usually each patient has a single doctor, though occasionally they will have two or more. Healthcare assistants (nurses) also attend to patients. A number of these nurses are assigned to each ward. A nurse is only assigned to one ward though a doctor can practice in all 18 wards. The hospital does not track the wards that the doctor visits. There is a 25-dollar billing charge that must be tracked each time a nurse visits a patient.
ERD using Cows foot notation
No of entities:
1. Patient entity
2. Ward entity
3. Doctor entity
4. Attend entity
5. Nurse entity
Relationship:
There are treated in relationship between Patient entity and ward entity
There are has relationship between Patient entity and Doctor entity
There are handle relationship between Nurse entity and Attend entity
There are visit to relationship between Attend entity and Patient entity
There are assigned to relationship between Ward entity and Nurse entity
Cardinality:
There are M:1 cardinality between Patient entity and ward entity
There are M:1 cardinality between Patient entity and Doctor entity
There are 1:M cardinality between Nurse entity and Attend entity
There are M:1 cardinality between Attend entity and Patient entity
There are 1:M cardinality between Ward entity and Nurse entity.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images
