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