Week 08

Announcements

The course book Database Systems: The Complete Book has finally arrived. You can pick it up at SDU's book store.

Lecture Monday (16.02.2009)

The fourth lecture 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 Wednesday (18.02.2009)

The fifth lecture will continue with 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

Exercise Thursday (19.02.2009)

More hands-on experience with SQL (finishing the tasks from Week 07) in IMADA's terminal room.