Not logged in. Login

CMPT 354 D1 Database Management Systems

Database Management Systems

CMPT 354

Simon Fraser University

Summer 2016

Inactive Links are Under Construction

Course Logistics

Instructor: Oliver Schulte
Office Location: TASC 1 9021.
Office Phone: 778-782-3390.
Office Hours: Thursday 10:30 am-12 pm.
E-mail Office Hour: Tuesday 11:30 am12:30 pm.

Teaching Assistant: Vivek Patel
Office Hours: Monday 12:00 PM - 1:00 PM
Office Location: ASB9808


Extra Office Hour for final exam: Thursday, June 23, 10:30 am.

Course Resources

Using SQL Server

  • We can not promise support for all platforms. Support is available for the setup in the CSIL lab. The databases you will need for this assignment and others are preloaded on the CSIL server.
  • Using SQL Server in CSIL. Here are some instructions for using SQL Server for those who are ready to start on this. The CSIL staff is reviewing our setup for the intersession, so these may be updated.
  • If you want to install a personal copy of SQL Server on your machine, you can use this: Installation Guide for the SQL Server 2012 Express. This includes instructions for how to import the Adventure Works database from a .bak file. If this doesn't work for some reason, you can try importing the data by running an SQL script. The SQL script is in the .sql file.


Midterm Resources

  1. Our Midterm
    1. Midterm Information. You can use a cheat sheet, 1 (one) 8.5 x 11 sheet of notes for reference, both sides.
    2. Midterm Instructions.
    3. Midterm Appendix. Keywords, Sample Queries shown as part of the midterm.
  2. Link to Previous Midterm 1
  3. Link to Previous Midterm 2
  4. Link to Previous Midterm 3

Final Exam Resources

  • Final Exam Date: Thursday, June 23, 2016 from 2:30-4:20 pm.
  • Final Exam Place: SSCC 9002
  1. Our Final Exam
    1. Final Exam Info You can use a cheat sheet, 1 (one) 8.5 x 11 sheet of notes for reference, both sides.
    2. First Two Pages of Final Exam Instructions and grading breakdown.
    3. Appendix of Final Exam
  2. Link1 to Previous Exam
  3. Link2 to Previous Exam

External Learning Resources


Updated Wed June 22 2016, 12:08 by oschulte.