Week 05

Course Book

The course book Database Systems: The Complete Book is available in SDU's book store. In case you have not gotten the book yet, the first two chapters are available online (Chapter 1, Chapter 2). Together with the material available under "Course Documents" on Blackboard, this should give you all the material needed for this week.

Lecture Wednesday (01.02.2012)

The first lecture will start with a short overview of the course organization. Then, after a short introduction to database systems, the relational data model will be introduced. This is the data model underlying nearly all common database systems. We will see how the SQL language can be used to define such models.

Topics

course organization, introduction to database systems, relational data model, SQL as a data definition language

Reading

Chapter 1, Chapters 2.1-2.3

Lecture Thursday (02.02.2012)

A relational database system has to allow flexible and efficient access to the data stored in the relations. The basic operations union, intersection, selection, projection, and various products provide a flexible framework for manipulating relations. Together, they constitute the "relational algebra" which is the topic of the second lecture.

Topics

relational algebra for sets, relational algebra for bags

Reading

Chapter 2.4, Chapter 5.1

Exercise Friday (03.02.2012)

Exercises 2.2.1-2.2.3, Exercises 2.3.1-2.3.2

Design by 1234.info | Modified by Peter Schneider-Kamp | CSS 2.0