Relational Data Model

Learning Objectives

• Describe the following concepts:
  • relation
  • tuple
  • attribute
  • referential integrity
• Define the following terms:
  • primary key
  • candidate key
  • foreign key
• List and describe the referential integrity actions

How to Complete this Lesson

Complete the following learning activities: (4 hours total)

1. Read the following chapters in Fundamentals of Database Management Systems:
   • Chapter 5: The Relational Database Model: Introduction (60 minutes)
   • Chapter 6: The Relational Database Model: Additional Concepts (45 minutes)
2. Attend the class meeting (60 minutes)
3. Take the quiz (10–12 minutes)
4. Start the Microsoft Access programming exercise (PEX) (60 minutes)
   • Complete Creating a Relational Database

Due

As a reminder, the following is due this lesson:

• Quiz: DBMS Concepts

---

« Database Management Systems Normal Forms I »