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: Friday 10:30-12 pm.
E-mail Office Hour: Monday 4:30-5 pm.

Teaching Assistant: Fatemeh Riahi
Email: sriahi@sfu.ca
Office Hours: Friday 10:30-11:30 AM
Office Location: ASB9838_TA_3

Announcements

Course Resources

• Syllabus
• Course Schedule
• Database Management Systems' website
• Submission Server
• SFU Medical Excuse Form.

Midterm Resources

1. Midterm Skeleton: 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
2. Final Exam Info
3. Link1 to Previous Exam
4. Link2 to Previous Exam

External Learning Resources

• Textbook website
• Changes in SQL:99 standards
• The 24x7 on-line book collection, for reference material. Log in to your library account, then search for books24x7 and "databases".
• Overview of ASP Net.
• Stanford Teaching Videos on Database Systems. You will need to register.

Assignments

• Assignment 1.
  • 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.
  • If you use your personal installation, you will need to import them. 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.
  • AdventureWorks Schema and Data Files
• Assignment 2.
  • 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. If you use your personal installation, you will need to import them.
  • Company Database: backup format.
  • StarWars Database: backup format.
  • Company Database: sql script.
  • Starwars Database: sql script.
• Assignment 3a.
  • To develop applications, you can use any programming language that works in with the CSIL database server Cypress in the CSIL environment. This includes Python, Visual Studio and Java for example. Most students have found Python by far the easiest to use for this assignment.
  • Visual Studio was developed to make this kind of application development easy. This applies to C# and Visual Basic. If you want to use Visual Studio, here are some more Visual Studio resources.
    • Flash Video for Database Connection.
    • Visual Studio Connection Example Code.
    • Overview of ASP Net.
  • CSIL has posted instructions for using Java. If you have trouble loading the driver, here is a possible solution for downloading it.
• Assignment 3b.
• Assignment4.

Slides

• Chapter 1.
• Chapter 2.
• Chapter 3.
• Chapter 4. Chapter 4 pdf for algebra symbols.
• Chapter 5. Updated Feb 13.
• Chapter 6. Updated March 19.
• Chapter 7.
• XML.
• Chapter 8.
• Chapter 12.