Notes

Outline

Slide 1

Chapter 5 The Relational Data Model and Relational Database Constraints

Relational Model Concepts Domains, Attributes, Tuples, and Relations Characteristics of Relations Relational Model Notation

Relational Model Constraints and Relational Database Schemas Domain Constraints Key Constraints and Constraints on Null Values Relational Databases and Relational Database Schemas Entity Integrity, Referential Integrity, and Foreign Keys Other Types of Constraints

Update Operations and Dealing with Constraint Violations The Insert Operation The Delete Operation The Update Operation

Summary