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).
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