ER Modeling I

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: (3.75 hours total)

1. Read Fundamentals of Database Management Systems Chapter 2: Data Modeling (45 minutes)
2. Attend the class meeting (60 minutes)
3. Start the Microsoft Access programming exercise (PEX) (120 minutes)
   • Complete Creating a Relational Database
   • Complete Performing Queries using Query-By-Example

Due

As a reminder, the following is due this lesson:

• Assignment: Introductions

Resources

• Questions for data modeling (45 minutes)

---

« Introduction

ER Modeling II »