Programming Languages (CS302 2007S)

Class 35: SQL (1): The Relational Model

Back to Declarative Langauges. On to SQL (2): SEQUEL.

This outline is also available in PDF.

Held: Wednesday, April 25, 2007

Summary: Today we begin our exploration of declarative database languages by considering one of the first papers on relational databases.

Related Pages:



What is a database?

How do we implement them (without a DBMS)?

What do we know about the state of computing (and databases) at the time this was written?

Codd's Contributions

What are the primary contributions of this paper? Here are some.

Why do we care about separating access from representation?

Why Read This Paper?

Up to you to answer this question.

Thinking About Relations

Codd treats relations in a variety of ways in the paper.

Operations on Relations

Back to Declarative Langauges. On to SQL (2): SEQUEL.

Disclaimer: I usually create these pages on the fly, which means that I rarely proofread them and they may contain bad grammar and incorrect details. It also means that I tend to update them regularly (see the history for more details). Feel free to contact me with any suggestions for changes.

This document was generated by Siteweaver on Sun Apr 29 11:26:47 2007.
The source to the document was last modified on Tue Jan 16 13:34:44 2007.
This document may be found at

You may wish to validate this document's HTML ; Valid CSS! ; Check with Bobby

Samuel A. Rebelsky,