Week 07

Announcements

The project for the course is available. Information about the database server will follow soon.

Exercise Tuesday (14.02.2012)

Time to get your hands dirty! This exercise will take place in IMADA's terminal room. You should get an account for the database server and set up a test database with the running examples from the lectures. Try some of the queries from the lecture on this test database. Then add some relations from the previous exercises and perform queries on them.

Lecture Wednesday (15.02.2012)

In the fourth lecture we will catch up with aggregate queries in SQL and extended relational algebra. Then we will introduce concepts needed for designing good relational databases. We will start on functional dependencies, decomposition of relations, and normal forms.

Topics

Functional Dependency, Anomalies, Decomposition, Boyce Codd Normal Form

Reading

Chapters 3.1-3.3

Lecture Thursday (16.02.2012)

The fifth lecture will continue with normal forms and introduce the third normal form (3NF). In the second half we will start on entity relationship diagrams (ER diagrams).

Topics

3rd Normal Form, ER diagrams

Reading

Chapters 3.4-3.5, Chapters 4.1-4.2