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

Monday 1 PM to 3 PM with Ritika Bahatia.

Tuesday 10 AM to 12 PM with Mehak Mustafa.

Wednesday 10 AM to 12 PM with Razieh Tekieh.

Thursday 3 PM to 5 PM with Shriya Satish.

Friday 9 AM to 11 AM with Anousheh Shahmirza.

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