[Announcements] [Lectures] [Syllabus] [Tutorials]

General Information

Professor: Iluju Kiringa (kiringa@site.uottawa.ca)

Office Hours: Tuesdays 12:00-1:00PM (Increased on rush days) SITE 5072

Lectures:
Tuesday 8:30-10:00AM in Vanier Hall Room 331
Friday 10:00-11:30AM in Vanier Hall Room 331

TAs: Yong Lin Ren (Yren009@site.uottawa.ca) and Guichong Li (jli136@site.uottawa.ca)

Overview

Topics: Views of data at different levels. Entity-relationship modelling. Relational data model. Relational algebra and calculi. Relational database languages. Application programming. Elements of query processing. Elements of transactions and concurrency. Data storage structures. Normal forms.

Prerequisites: Required is a solid knowledge of files structures at the level of CSI2131 (or its equivalent CSI2531).

Text book: R. Ramakrishnan and J. Gehrke, Database Management Systems. 3rd Ed., McGraw Hill, 2003.

Software: PostgreSQL; PGADMIN