Database Systems I

CMPT 354 - D1
Fall 2015

James Delgrande
School of Computing Science
Simon Fraser University

General Information

Lecture times:
- MWF 11:30 - 12:20 in AQ 3005
Instructor: Jim Delgrande, TASC I, 9015;
- Email: jim
- Office Hours: Tuesday and Thursday, 14:00-15:00
TA: Bhagyasri Velpula,
- Email: bvelpula
- TA Office Hours: Monday and Friday 13:00-14:00, in CSIL
Grading: Assignments 40%, Midterm Exam 20%, Final Exam 40%.
Midterm test: The midterm will be on October 26.
Final Exam: 11 December 8:30 -- 10:30 in AQ 3182 (NB: you must be able to attend the exam.)

Topics

We will be covering the following topics in the course.
(Note the order doesn't correspond to the order of chapters in the text, and I may deviate from the order in the list.)

Introduction
The Relational Model
Database Design: The Entity-Relationship Model
SQL
Advanced SQL
Relational Database Design: Normalization and Functional Dependencies
XML

If time permits, we may also cover the following topics.

Datalog
Data Analysis and Mining

Announcements

Sept 28: In Assignment 1, Question 1, Parts b and c, where it askes for an address, just find the city of the dealership.
Oct 12: The midterm test will be Monday, October 26.
- If your last name starts with A-P, you will write the test in AQ3005; if your last name starts with Q-Z, you will write the test in BLU10011.
October 28: The final exam will be on 11 Dec, 08:30-10:30, in AQ3182.

Assignments

Assignment 1 (due October 5)
Assignment 2 (due October 26)
- Here are the tables for the assignment: zipped
- See www.sfu.ca/computing/about/support/csil/windows/how-to-use-sql.html for details on using Microsoft SQL Server on CSIL
Assignment 3 (due Nov 16)
- Here is the table for the assignment: EnrollmentsWithGrades.txt
Assignment 4 (due Dec 7)

Course Materials

Text

Jeffrey Ullman and Jennifer Widom, A First Course in Database Systems, Third Edition, 2008.

Lecture Notes

Here are the slides for the lectures. I will try to make each week's slides available shortly before class.

Policies:

All assignments are due at 23:59 p.m. on the day indicated. Late assignments will not be accepted unless there is a documented medical reason.
Please notify the TA or myself of any concerns regarding marking of an assignment or test within one week of it beig returned.
There will be no makeup midterm or final exams. You must be able to write the midterm or final when they are given. The only exceptions are for documented medical reasons or unpredictable and serious personal reasons.
All work must be done singly by the student, and not in collaboration with others. All sources used must be cited.
Students must attain an overall passing grade on the weighted average of exams in the course in order to obtain a clear pass (C or better).