ER Model

Database Systems - CS2300 - 8 March 2018

Database Design

  • Data Model is a group of concepts that helps to specify the structure of a database and a set of associated operations allowing data retrieval and manipulation.

  • An entity type is represented by a rectangular box
  • An attribute is represented by an oval attached to the entity type
  • Composite attribute is attached to components
  • Multi-value attributes are represented by a double oval