Module 3: The Relational Model II

CMPS 160: Databases


The foundation of most databases is the relational model. If you have ever used a spreadsheet program like Microsoft Excel you are familiar with the table format. In addition, spreadsheet software can have references from one cell, row, or column to other cells, rows, or columns. Databases mimic this structure but there are very important differences that this module will emphasize. In essence, databases enforce strict rules in terms of what data can stored in each row (record), column (field), and what can reference what. This is the relational model. A useful rule of thumb is that any redundant information in the data model or database design indicates a mistake.

Module Objectives

  • Learn the conceptual foundation of the relational model
  • Understand how relation differ from nonrelational tables
  • Learn basic relational terminology
  • Learn the meaning and importance of keys, foreign keys, and related terminology
  • Understand how foreign keys represent relationships
  • Learn the purpose and use of surrogate keys
  • Learn the meaning of functional dependencies
  • Learn to apply a process for normalizing relations

Learning Resources

  • Module 3 Readings: Chapter 2
  • Module 3 Slides: Chapter 2

Learning Activities

  • Module 3 Assignment: Chapter 2 Regional Labs Case Questions

For Further Study

It is highly recommended to work through the exercises at the end of the chapter, specifically:

  • 2.24
  • 2.25 and 2.26
  • 2.28
  • 2.32, 2.33, and 2.34 (can you solve these problems?)
  • Garden Glory Project Questions

Leave a Reply

Your email address will not be published. Required fields are marked *