Create a Conceptual ER Diagram for the Mountain View Community Hospital case described at the end of Chapter 3 (pages 147-149). You can ignore the volunteer application form (Figure 1). The diagram should include 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 not derived). 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 not be 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 be reasonable and should not contradict the facts of the case _ A soft copy of your completed assignment including the cover sheet (with assumptions, if any)
Already registered? Login
Not Account? Sign up
Enter your email address to reset your password
Back to Login? Click here