Overview

Welcome to the web page of COMP 3005 - Database Management Systems. This course is on the databases and database management systems. We will talk about relational algebra and SQL, database design, and the internals of database management systems like storage and indexing, query processing and optimization, transactions and concurrency control.

Time: Tuesdays and Thursdays from 1:05 PM to 2:25 PM
Location: Azrieli Theatre 101

Office Hours

I'm holding my office hours on Tuesdays at 3:15 PM in HP 5433. The TAs will hold their office hours in HP 4125.

TAs

Contact Information

Herzberg Laboratories 5433
1125 Colonel By Dr
Ottawa, Ontario K1S 5B6

613-520-2600 ext. 4254
myFirstName.myLastNameWithoutHyphen@carleton.ca

There's also this anonymous feedback form, in which you can swear at me. But during the swearing spree, please give me some constructive feedback.

Grading

You'll be graded based on your assignments, midterm exam, and final exam. Following is the marks breakdown:

  • Assignments 25%
  • Midterm 25%
  • Final 50%

Assignments

There will be 6 assignments throughout the term. Five of the six assignments will count. The worst grade you'll get for any of the assignments will be dropped. In other words, the highest five grades you'll receive for your assignments will count for the 25% of your final grade in the course. The assignments will be posted and submitted on culearn.

Midterm

There will be a midterm exam that will take place in class on October 29th.

Final

The final exam day will be announced on October 11th. The exam day will be in the period from December 9th to December 21st. You will need to get at least 45% of the total marks of the final exam to pass this course.

Schedule

Date Topic Material
September 5th Course Introduction, History of DBMS, and Relational Algebra Slides
September 10th Introduction to SQL Slides
September 12th Aggregation in SQL Slides
September 19th Joins Slides
September 24th Advanced SQL Slides
September 26th Overview of Database Design Slides
October 1st Entity Relationship Model Slides
October 8th ER-Diagram to Relational Schemas Slides
October 10th Relational Database Design Slides
October 15th Normalization Theory (1) Slides
October 17th Normalization Theory (2) Slides
October 31st Physical Storage Slides
November 5th File Organization (1) Slides
November 7th File Organization (2) Slides
November 12th Indexing Slides
November 14th B+-tree Slides
November 19th B+-tree/Hash Indexing Slides
November 26th Query Processing Slides
November 28th Query Processing Slides
December 3rd Query Processing Slides
December 5th N/A