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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.