 |
CMPT 354 D1 Database Systems I |
News:
Back to Top
17/12/08 - Solution of final exam posted
28/11/08 - Sample final exam posted
24/11/08 - Pdf-versions of the recent slides posted
20/11/08 - Deadline for assignment 8 extended
07/11/08 - Grading scheme changed, as discussed in class
07/11/08 - Assignment 8 and solution of Assignment 7 posted
06/11/08 - Time and location of the final exam posted
24/10/08 - Solutions to the chapter exercises of the Ramakrishnan/Gehrke book posted
23/10/08 - Review of the midterm solution and common mistakes in class on Friday, October 24
11/10/08 - Review for the midterm exam in class on Wednesday, October 15
03/10/08 - Office hours changed to 2:00 to 4:00 pm
03/10/08 - Assignment 4 and Solution 3 posted
27/09/08 - Assignment 3 posted
26/09/08 - Lecture slides "SQL constraints" posted
24/09/08 - New course website goes live
28/11/08 - Sample final exam posted
24/11/08 - Pdf-versions of the recent slides posted
20/11/08 - Deadline for assignment 8 extended
07/11/08 - Grading scheme changed, as discussed in class
07/11/08 - Assignment 8 and solution of Assignment 7 posted
06/11/08 - Time and location of the final exam posted
24/10/08 - Solutions to the chapter exercises of the Ramakrishnan/Gehrke book posted
23/10/08 - Review of the midterm solution and common mistakes in class on Friday, October 24
11/10/08 - Review for the midterm exam in class on Wednesday, October 15
03/10/08 - Office hours changed to 2:00 to 4:00 pm
03/10/08 - Assignment 4 and Solution 3 posted
27/09/08 - Assignment 3 posted
26/09/08 - Lecture slides "SQL constraints" posted
24/09/08 - New course website goes live
Back to Top
Course Information:
Back to Top
Classroom: BH 10011
Lecture: Monday, Wednesday and Friday 10:30 - 11:20 am
Course Textbook: A First Course in Database Systems by Ullman and Widom, Prentice Hall, 3rd edition, 2007.
Online material provided by the authors
Solutions for the odd-numbered chapter exercises of the Ramkrishnan/Gehre book
Lecture: Monday, Wednesday and Friday 10:30 - 11:20 am
|
Instructor: Email: Office: Office Hours: |
Martin Ester ester@cs.sfu.ca TASC1 9231 Monday, 2:00 - 4:00 pm |
TA: Email: Office: Office Hours: |
Gustavo Frigo gafrigo@sfu.ca ASB 9838 Wednesday, 1:30 - 3:30 pm |
Course Textbook: A First Course in Database Systems by Ullman and Widom, Prentice Hall, 3rd edition, 2007.
Online material provided by the authors
Solutions for the odd-numbered chapter exercises of the Ramkrishnan/Gehre book
Back to Top
Course Schedule:
Back to Top
Week Sept 3 - 5 Sept 8 - 12 Sept 15 - 19 Sept 22 - 26 Sept 29 - Oct 3 Oct 6 - 10 Oct 13 - 17 Oct 20 - 24 Oct 27 - 31 Nov 3 - 7 Nov 10 - 14 Nov 17 - 21 Nov 24 - 28 Dec 6 |
Lectures (sections of the textbook) Introduction / Relational Data Model (2.1 - 2.2) Relational Data Model (7.1 and 2.3) / Relational Algebra (2.4) SQL Queries (6.1 - 6.4) SQL Modifications and Transactions (6.5 - 6.6) SQL Constraints and Triggers (7.2 - 7.5) Entity-Relationship Model (4.1 - 4.6) Design Theory for Relational Databases (3.1 - 3.5) Midterm Exam (Monday, October 20) SQL in a Server Environment (9.1 - 9.2) SQL in a Server Environment (9.3 - 9.6) Semistructured Data Model (11.1 - 11.4) Query Languages for XML (12.1 - 12.2) Online Analytic Processing (10.6 - 10.7) Final Exam (Saturday, December 6, 8:30 to 11:30 am, WMC 3260) |
Assignments Relational Algebra Queries on SQL Server (AdventureWorks DB) SQL queries and modifications SQL constraints and triggers Importing data for the Movie DB SQL queries on the Movie DB ER Diagrams and Relational Design Theory Implementation of a movie recommender XML and XML queries |
Back to Top
Lecture Notes:
Back to Top
Introduction
The Relational Data Model
Relational Algebra
SQL Queries [pdf file] [ppt file]
SQL Modifications and Transactions [pdf file] [ppt file]
SQL Constraints and Triggers [pdf file] [ppt file]
Entity Relationship Model [pdf file] [ppt file]
Design Theory for Relational Databases [pdf file] [ppt file]
SQL in a Server Environment [pdf file] [ppt file]
Semistructured Data Model [pdf file] [ppt file]
Query Languages for XML [pdf file] [ppt file]
Data Warehousing [pdf file] [ppt file]
The Relational Data Model
Relational Algebra
SQL Queries [pdf file] [ppt file]
SQL Modifications and Transactions [pdf file] [ppt file]
SQL Constraints and Triggers [pdf file] [ppt file]
Entity Relationship Model [pdf file] [ppt file]
Design Theory for Relational Databases [pdf file] [ppt file]
SQL in a Server Environment [pdf file] [ppt file]
Semistructured Data Model [pdf file] [ppt file]
Query Languages for XML [pdf file] [ppt file]
Data Warehousing [pdf file] [ppt file]
Back to Top
Assignments:
Back to Top
For paper and pencil assignments, drop hard copies of your solutions into the CMPT 354 D1 Ester box in the CSIL lab. For programming assignments, submit your solution to the online submission server. Deadline for the assignments is Friday before class, i.e. before 10:30 am.
Assignment 1, assigned September, 12 and due September, 19
Solution Assignment 1
Assignment 2, assigned September, 19 and due September, 26
Solution Assignment 2
Assignment 3, assigned September, 27 and due October, 3
Solution Assignment 3
Assignment 4, assigned October, 3 and due October, 10
Solution Assignment 4
Assignment 5, assigned October, 11 and due October, 24
Assignment 6, assigned October, 24 and due October, 31
Solution Assignment 6
Assignment 7, assigned October, 31 and due November, 7
Solution Assignment 7
Extra Assignment, assigned November 1, not marked
Solution Extra Assignment
Assignment 8, assigned November, 7 and due November, 24 (deadline extended)
Assignment 9, assigned November, 21 and due November, 28
Solution Assignment 9
* All assignments are due at the start of class on the day indicated. Late assignments will not be accepted unless there is a documented medical reason. There will be no makeup midterm or final exams. If you are unable to write the midterm or final, please contact the instructor before the exam.
* Grading scheme: Assignments 50%, Midterm exam 12.5%, Final exam 37.5%.
* 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).
Assignment 1, assigned September, 12 and due September, 19
Solution Assignment 1
Assignment 2, assigned September, 19 and due September, 26
Solution Assignment 2
Assignment 3, assigned September, 27 and due October, 3
Solution Assignment 3
Assignment 4, assigned October, 3 and due October, 10
Solution Assignment 4
Assignment 5, assigned October, 11 and due October, 24
Assignment 6, assigned October, 24 and due October, 31
Solution Assignment 6
Assignment 7, assigned October, 31 and due November, 7
Solution Assignment 7
Extra Assignment, assigned November 1, not marked
Solution Extra Assignment
Assignment 8, assigned November, 7 and due November, 24 (deadline extended)
Assignment 9, assigned November, 21 and due November, 28
Solution Assignment 9
* All assignments are due at the start of class on the day indicated. Late assignments will not be accepted unless there is a documented medical reason. There will be no makeup midterm or final exams. If you are unable to write the midterm or final, please contact the instructor before the exam.
* Grading scheme: Assignments 50%, Midterm exam 12.5%, Final exam 37.5%.
* 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).
Back to Top