With so much data available today, it’s critical to understand what matters to an organization: i.e., what is needed to support the organization’s business processes and to give it a competitive advantage? Data modeling provides a consistent way to record the concepts and relationships among them for a particular business context. Entity-relationship (ER) models are the most common approach to diagram this information when designing a database.

Learning Objectives

  • Define the following terms:
    • entity
    • attribute
    • relationship
  • Construct a simple ER model for a real-world system

How to Complete this Lesson

Complete the following learning activities: (1.75 hours total)

  1. Read Fundamentals of Database Management Systems Chapter 2: Data Modeling (45 minutes)
  2. Attend the class meeting (60 minutes)
« Introduction ER Modeling II »