CMPT 354 Spring 2013

Announcements

Course Resources

• Syllabus
• Course Schedule
• Database Management Systems' website
• Submission Server
• Studio Connection Example Code
• Flash Video for Visual Studio and Database Connections
• SFU Medical Excuse Form.
• Installation Guide for the SQL Server 2012 Express. This is a guide for the do-it-yourself approach to setting up SQL Server. We can not promise support for all platforms. You can also use the setup in the CSIL lab, for which support is available.

Midterm Resources

1. Midterm Skeleton: Previous Instructions and Appendix.
2. Link to Previous Midterm 1
3. Link to Previous Midterm 2
4. Link to Previous Midterm 3

Final Exam Resources

1. Final Exam Instructions and other parts. The same in both sections, except the points are distributed a little bit differently across sections. The total number of points is the same.
2. Final Exam Info
3. Midterm Skeleton: Previous Instructions and Appendix.
4. Link1 to Previous Exam
5. Link2 to Previous Exam

External Learning Resources

• Database Management Powerpoint on XML.Systems textbook website
• Changes in SQL:99 standards
• The 24x7 on-line book collection, for reference material.
• Overview of ASP Net.
• Stanford Teaching Videos on Database Systems. You will need to register.

Assignments

• Assignment 1:
  • Download the assignment: . (Revised Jan 23).
  • Submission Instructions.
  • Setting Up SQL Server.
  • AdventureWorks Schema
  • AdventureWorksLT.sql.db.zip
• Assignment 2:
  • Download the assignment:
  • Submission Instructions.
  • Company Database: backup format
  • StarWars Database: backup format.
  • Company Database: sql script
  • StarWars Database: sql script
• Assignment 3.
  • Download the assignment:
  • Submission Instructions.
• Assignment 4.
  • Download the assignment:
  • Submission Instructions.

Slides

• Chapter 1
• Chapter 2
• Chapter 3
• Chapter 4
• Chapter 5
• Chapter 6
• Chapter 7
• Chapter 8
• Chapter 12
• Powerpoint on XML. PDF on XML.