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
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).