CMPT 354 Database Systems and Structures

Classroom: AQ 3003

Lecture: Wednesdays 17:30 – 20:20
 

Instructor:	Gordon Louie	TA:	Dulce Aguilar-Solis
Email:	louie@cs.sfu.ca	Email:	dma@cs.sfu.ca
Office:	ASB 10863	Office:	ASB 9804
Phone:	291-3244/663-1849 msg.	Phone:	(use email)
Office Hours:	Thurs. 18:00 - 19:00  Or by appointment.	Office Hours:	Mon. 16:30 - 18:30  Fri. 16:30 - 18:30

Textbook/Notes:	CMPT 354 Class Notes, Han, SFU/CS (also available online)
	Database Systems Concepts, 3rd Edition., Korth & Silberschatz, McGraw-Hill  Link to Korth & Silberschatz's "Database System Concepts" chapter slides (PDF format)

Policies:

• All assignments are due on the day indicated. There will be a 10% penalty for each day an assignment is late (including weekends and holidays), unless there is a documented medical reason.
• There will be no makeup midterm or final exams.  If you are unable to write the midterm or final, please contact the instructor before the exam.

Resources:

CMPT 354 Course Outline

CMPT 354 Lecture Schedule

Electronic copy of CMPT 354 course notes (Courtesy of Dr. Zaiane).

Equivalent Notations in Relational Languages (pdf)

SQL Server Help Sheet (pdf)
 

Practice Exercises:
 

Chapter 2 - ER model (pdf)	Chapter 2 - Sample Answer (pdf)
Chapter 3 - Relational Languages (pdf)	Chapter 3 - Sample Answer (pdf)
Chapter 4 - SQL (pdf)	Chapter 4 - Sample Answer (pdf)
Chapter 5 - QBE (pdf)	Chapter 5 - Sample Answer (pdf)
Chapter 6 - Integrity Constraints (pdf)	Chapter 6 - Sample Answer (pdf)
Chapter 7 - Database Design (pdf)	Chapter 7 - Sample Answer (pdf)
Chapter 10 - Storage & File Structure (pdf)	Chapter 10 - Sample Answer (pdf)
Chapter 11 - Indexing & Hashing (pdf)	Chapter 11 - Sample Answer (pdf)
Chapter 12 - Query Processing (pdf)	Chapter 12 - Sample Answer (pdf)

Hand-in Exercises:
 

Assignment 1 (pdf)	Assignment 1 Answer Key (pdf)
Assignment 2 (pdf)	Assignment 2 Answer Key (pdf)
Assignment 3 (pdf)	Assignment 3 Answer Key (pdf)
Assignment 4 - Project (pdf)
Midterm Solution (pdf)