CMPT 354 Summer 2011
Instructor:
Oliver Schulte (oschulte[at]cs.sfu.ca)
Office Hours: Monday 3:30-4:30 pm
Office Location: TASC I: 9021
Office Phone: 778-782-3390
Oliver Schulte (oschulte[at]cs.sfu.ca)
Office Hours: Monday 3:30-4:30 pm
Office Location: TASC I: 9021
Office Phone: 778-782-3390
Teaching Assistants:
Yi Cui (cuiyic[at]sfu.ca)
Amir Hedayaty (aha49[at]sfu.ca)
Office Hours: Fridays 15:30-16:30
Office Location: ASB9838(CSIL) TA_2
Include 354 in the title otherwise emails may be ignored.
Yi Cui (cuiyic[at]sfu.ca)
Amir Hedayaty (aha49[at]sfu.ca)
Office Hours: Fridays 15:30-16:30
Office Location: ASB9838(CSIL) TA_2
Include 354 in the title otherwise emails may be ignored.
Announcements
Resources
- Syllabus
- Course Schedule
- Database Management Systems' website
- Submission Server
- Changes in SQL:99 standards
- Studio Connection Example Code
- The 24x7 on-line book collection, for reference material.
- Overview of ASP Net
Midterm Resources
- Midterm Skeleton: Instructions and Appendix.
- Link to Previous Midterm 1
- Link to Previous Midterm 2
- Link to Previous Midterm 3
Final Exam Resources
Assignments
- Assignment 1:
- Download the assignment:
- Schema
- AdventureWorksLT.sql.db.zip
- Setup Guide
- List of common mistakes
- Download the assignment:
- Assignment 2:
- Download the assignment:
- Company
- StarWars
- How to Import MDB files to SQL Server
- Suggested Solutions
- Supplement on Relational Algebra Queries. Optional set of exercises for fulfilling the relational algebra part of Assignment 2. Solutions For 2a
- Download the assignment:
- Assignment 3.
- Download the assignment:
- Submission Details
- Download the assignment:
- Assignment 4.
- Download the assignment:
-
Solutions
- Download the assignment:
Slides
-
Chapter 2
-
Chapter 3
-
Chapter 4
-
Chapter 5
-
Chapter 6
-
Chapter 7
-
Chapter 8
-
Chapter 12
-
Chapter 19