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

General Information

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

Office Hours: Thursdays 11:30AM-1:30PM (Increased on rush days) SITE 5072

Lectures:
Section A -- Tuesday 8:30-10:00AM in Sports Complex E218; Friday 10:00-11:30AM in Sports Complex E218
Section B -- Tuesday 11:30AM-1:00PM in Sports Complex E218; Friday 1:00PM-2:30PM in Sport Complex E218

TAs: Zhiyong Weng (zweng069@site.uottawa.ca), Taeho Jo (tjo018@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. Query processing. Transactions and concurrency. Data storage structures. Integrity constraints and normal forms. A few advanced topics such as Datawarehousing.

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