CHAPTER 

4

The Relational Model

TABLE OF CONTENTS

4.1    Advantages of the Relational Model

4.2    Relational Data Structures

4.3    Integrity Constraints: domain, key, foreign key, general constraints

4.4    Representing Relational Database Schemas

4.5    Relational Data Manipulation Languages

4.6    Views

4.7    Mapping an E-R Model to a Relational Schema

4.8    Mapping an EE-R Model to a Relational Schema

4.9    Chapter Summary

Exercises

CHAPTER OBJECTIVES

In this chapter you will learn the following:

  Some advantages of the relational model

  How tables are used to represent data

  Characteristics of database relations

  The meaning of entity integrity and referential integrity

  The categories of relational languages

  How to ...

Get Databases Illuminated, 3rd Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.