This course is an introduction to the design and implementation of relational database management systems. Topics covered include the relational model, ER design, database design, integrity constraints, relational algebra, SQL query language, transactions, concurrency control, and sustainability.
Course work will include assignments, a midterm, and a final exam. Graduate students taking SE 6DB3 will be expected to complete an additional project and presentation in consultation with the instructor.
Prerequisites: one of CS 1FC3, SE 2DM3.
Lectures: Mon,Wed at 11:30am-12:20pm, Fri at 1:30pm-2:20pm, PC 155
Tutorials: Mon (T01) at 12:30pm - 1:20pm, or Tues (T02) at 1:30pm - 2:20pm, T13/107
Professor: Fei Chiang
Textbook: The required textbook for this course is "Database Management Systems" (3rd edition) by R. Ramakrishnan, J. Gehrke. It is available at the McMaster University bookstore.