CS 3DB3/SE 4DB3: Database Systems (Winter 2014)


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.

Course Time:
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

Email: fchiang [at] mcmaster [dot] ca
Office Hours: Fri 2:30pm-3:30pm, or by appointment, ITB 122

Teaching Assistants:

  • Xiao Jiao Wang:
    • Email: wangxj2 [at] mcmaster [dot] ca
    • Office hours: Mon 2:30pm-3:30pm, ITB 115
  • Ruifeng Zou:
    • Email: zour2 [at] mcmaster [dot] ca
    • Office hours: Wed 2:30-3:30pm, ITB 224

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.

News

  • Apr 16: Asg 3 grades posted (avg = 76%). Sample soln and marking scheme available on Avenue ('Content'-> 'Asg 3').
  • March 12: University closed as of 11:30am. No class today.
  • Asg. #3 is posted.
  • Grad project presentation info and schedule posted.
  • Midterm is on Feb 26 during class time (11:30am), PC 155. No aids allowed.
  • Asg. #2 is posted.
  • Practice midterm and exercises posted (under Schedule, Feb 7).
  • Asg. #1 is posted.
  • TA office hour update: For weeks of Jan 20/27, Wed office hours moved to Thurs, same time. That is, Ruifeng will hold office hours Jan 23, 30 at 2:30pm-3:30pm, ITB 224.
  • Dec 20: First class is Jan 6. Tutorials start week of Jan 13.