Education > Information Central > Course Central > CS Instructional Labs
Database Systems I [CMPT 354-D1] - Fall 2010 Course Home Page
Instructor: Richard Frank Ph.D.
Assignments
All assignments are due immediately before class on the Thursday of the week indicated on the assignment. For example, Assignment #1 is due on September 16 at 14:30. For electronic submissions, submit your solution to the online submission server. For paper assignments, hand in hard copies of your assignments before lecture.There are in total 11 assignments, all worth 5%. At the end of the course, the best 10 of 11 assignments will make up the Individual Assignment portion of your course grade.
All paper-based submissions should be 1.5-spaced, 1” margins, size 10 font. Page requirements include all references, images/diagrams, but not cover pages.
Although there will be theory/conceptual questions on the assignments, we will also apply the course material in a practical setting, and thus some assignment questions will require programming. Programs must be written in VB.NET or C# as part of Visual Studio (VS) 2010, or below, package. The database component must be SQL Server 2008 R2, or below. Express [free] editions of both these software are available at http://www.microsoft.com/express/downloads/ and via CS@SFU.
Some assignments will require programming a stand-alone application, and others a web-based application (both can be done via VS). The entire VS Project, and the corresponding database, must be submitted as part of the assignment. Code must be documented to a level sufficient to easily understand the code. This means document what the INPUT and OUTPUT are, along with any sections of code that are not obvious. Do not write a book.
Assignment 01: Database Uses [DOCX] [PDF]
Solution: N/A
Assignment 02: ER Diagram & AdventureWorksLT [DOCX] [PDF]
Database AdventureWorksLT
Database Schema [PNG]
![[PNG]](content/AdventureWorks%20Schema.png){kind=link}
Database Setup Instructions [DOCX] [PDF]
Solution [PDF]
Assignment 03: Relational Model [DOCX] [PDF]
Required ER Diagram [PDF]
Solution [PDF] [CODE]
Assignment 04: Relational Algebra [DOCX] [PDF]
Solution [PDF]
Corrected Solution for Question 1 [PDF]
Assignment 05: SQL Commands/Application [DOCX] [PDF]
Assignment 06: SQL Commands/Transactions [DOCX] [PDF] - Change: Due Nov 2
Good Walkthrough for Procedures: http://www.sql-server-performance.com/articles/dba/stored_procedures_basics_p1.aspx
Solution [PDF]
Mid-Term Solutions [PDF]
Assignment 07: Triggers/Functions/Procedures [DOCX] [PDF]
Solution [PDF]
Assignment 08: SQL Injection and Table Permissions [DOCX] [PDF]
Solution [PDF]
Assignment 09: Internet Applications [DOCX] [PDF]
Tiny Sample Application [RAR]
Note: Don't make this into a complicated assignment.
Assignment 10: XPath/XQuery [DOCX] [PDF]
Program to test XQueries [EXE] [Source]
XML File [XML]
Solutions [PDF]
Assignment 11: Review & Normal Forms [DOCX] [PDF]
Solutions [PDF]
Course Evaluation
| Individual Assignments | 50% |
| Midterm Exam | 20% |
| Final Exam | 30% |
Last Update:12/06/2010