Table of Contents
Review of the Relational Data Model
Outline of the lecture
Why Study the Relational Model?
Relational Database: Definitions
Example Instance of Students Relation
Creating Relations in SQL
Creating Relations in SQL
Adding and Deleting Tuples
Integrity Constraints (ICs)
Primary Key Constraints
Primary Keys in SQL
Foreign Keys, Referential Integrity
Foreign Keys in SQL
Enforcing Referential Integrity
Enforcing Referential Integrity
Where do ICs Come From?
Relational Query Languages
The SQL Query Language
Querying Multiple Relations
Semantics of a Query
Cross-product of Students and Enrolled Instances
Relational Model: Summary
The End
|
Author: Raghu Ramakrishnan
|