14.1 KEY POINTS

  • List everything, tangible or intangible, you want to keep track of. If there are existing reports or any data forms, browse them and discover objects that requires a lpermanent storage.

  • Model each of them in an enity.

  • Give each entity a meaningful name.

  • Assign each entity a set of attributes, i.e., properties which describe each entity instance.

  • (Determine the identifier for each entity)

  • Discover the relationships between entities

  • For each relationship, determine the cardinality for both minimum and maximum participation.

  • Visualize the ER model in a diagram with Crow’s Food notation

  • Present the model