CSCI 320 - Database design
  • Home
  • Schedule / Lecture Notes / Assignments
    • Week 1
    • Week 2
    • Week 3
    • Week 4
    • Week 5
    • Week 6
    • Week 7
    • Week 8
    • Week 9
    • Week 10
    • Week 11
    • Week 12
    • Week 13
    • Week 14
    • Week 15
    • Week 16
  • Project
  • Contact
  • Home
  • Schedule / Lecture Notes / Assignments
    • Week 1
    • Week 2
    • Week 3
    • Week 4
    • Week 5
    • Week 6
    • Week 7
    • Week 8
    • Week 9
    • Week 10
    • Week 11
    • Week 12
    • Week 13
    • Week 14
    • Week 15
    • Week 16
  • Project
  • Contact
CSCI 320 - Database design
Week 2 - Data Modeling
Topics Include:
  • Data Definitions
  • Business Rules
  • E-R Model --> Entities
  • E-R Model --> Relationships
  • E-R Model --> Cardinality Constraints
Download PowerPoint:
  • Data Modeling
Related Readings:
  1. 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. 
Y
our 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

Powered by Create your own unique website with customizable templates.
✕