Week 2 - Data Modeling
Topics Include:
Assignment 2:
Read the case description for Mountain View Community Hospital on page 110 in your books.
Draw an E-R diagram for the Mountain View Community Hospital based on the entity and relationship descriptions given on page 110. State any assumptions you made in developing the diagram.
Your E-R diagram needs to be drawn using a computer-based tool. Please explore several free to use E-R modeling tools available online, or you may also use PowerPoint or Paint programs. Hand drawn models will not be accepted.
Database Term Project
Topics Include:
- Data Definitions
- Business Rules
- E-R Model --> Entities
- E-R Model --> Relationships
- E-R Model --> Cardinality Constraints
- Chapter 2 from Modern Database Management
Assignment 2:
Read the case description for Mountain View Community Hospital on page 110 in your books.
Draw an E-R diagram for the Mountain View Community Hospital based on the entity and relationship descriptions given on page 110. State any assumptions you made in developing the diagram.
Your E-R diagram needs to be drawn using a computer-based tool. Please explore several free to use E-R modeling tools available online, or you may also use PowerPoint or Paint programs. Hand drawn models will not be accepted.
Database Term Project