DM505, Spring 2006, 4th Quarter - Weekly Note 5

This week, there will be exercises Monday, and lectures Wednesday and Thursday.

Lecture May 1

More on SQL: aggregations, NULL values, outer joins. Use of the PostgreSQL system at IMADA. Start on functional dependencies and normal forms.

Reading

Ramakrishnan and Gehrke: Sections 5.5-6, and 19.1-3. Note on using PostgreSQL at IMADA.

Lecture May 4

More on functional dependencies and normal forms.

Reading

Ramakrishnan and Gehrke: Sections 19.3, 19.4.1, 19.6.1.

Lecture May 10 (Expected contents)

End of functional dependencies and normal forms. Some left-over bits of SQL: general constraints, triggers, views. Database application programming using JDBC. Stored procedures.

Reading

Ramakrishnan and Gehrke: Rest of Sections 19.4-7. Sections 5.7-9 and 3.6. Sections 6.3 and 6.5. Note on using JDBC with PostgreSQL at IMADA.

Lecture May 11 (Expected contents)

Index structures.

Reading

Ramakrishnan and Gehrke: Chapters 10 and 12.

Exercises May 8

Exercises 5.2 and 5.5 in Ramakrishnan and Gehrke (try (some of) your solutions for the exercises in Chapter 5 on the example data given on the last weekly note).

Exercises 19.1 (except questions 3 and 4), 19.3, and 19.7 (in question (b), only consider whether the relation is in BCNF) in Ramakrishnan and Gehrke.