CMPT 354 Fall 2014 (Surrey) - Database Systems I

Course Information

This is an introductory course on Database Management Systems (DBMSs). We will cover the most widely used relational data model, database design, database usage including the query language (SQL). The official outlines can be found here: CMPT 354 D200.

• Instructor: Juhua Hu, juhuah@sfu.ca.
  Office Hours: Wednesdays/Fridays: 1:30 PM - 2:30 PM, at SUR 4142.
  Office Phone: 778-782-7585. Only available during the office hours.
  E-mail Office Hour: R 9 AM -9 PM. Include 354 in the title otherwise emails may be ignored.
• Teaching Assistant: Subir Ranjan, sranjan@sfu.ca.
  Office Hours: Tuesdays from Sep. 9: 11:00 AM - 12:00 PM, at SUR 4064.
• Lectures: Mondays/Wednesdays/Fridays 12:30 PM - 1:20 PM, at SUR 5140.

Lecture Topics

• Introduction: Slides (PDF) (Chapter 1)
• Entity Relationship Model: Slides (PDF) (Chapter 2, omit 2.7)
• Relational Model: Slides (PDF) (Chapter 3, omit 3.6.2)
• Relational Algebra: Slides (PDF) (Chapter 4, omit 4.3, 4.4)
• SQL: Slides (PDF) (Chapter 5)
• SQL Constraints: Slides (PDF) (Chapter 5)
• DB Applications: Slides (PDF) (Chapter 6)
• Midterm Announcements: Slides (PDF)
• Web Applications: Slides (PDF) (Chapter 7, omit 7.4)
• XML: Slides (PDF) (Chapter 7.4. and XPath uses Chapter 27.7.1. as a resource)
• Storage and Indexing: Slides (PDF) (Chapter 8)
• Query Evaluation: Slides (PDF) (Chapter 12)
• Final Announcements: Slides (PDF)

Assessment (Tentative)

• 4 Assignments: 10% each. Submissions are only accepted through CS CourSys system. Scanning of hand written ones should be as clear as possible, otherwise no arguments are accepted.
• Assignment 1: You can download the database for Part III here (right click and save as). Due by 11:59pm on Friday the 19th of September.
• Assignment 2: You can download the database for Part II here (right click and save as). Due by 11:59pm on Friday the 10th of October.
• Assignment 3: You can download the database here (right click and save as). Due by 11:59pm on Wednesday the 5th of November.
• Assignment 4: Due by 11:59pm on Wednesday the 26th of November.
• Midterm: 20%. October 17th, Friday, 12:30 PM in class.
• Final Exam: 40%. December 4th, Thursday, 12:00 PM - 3:00 PM at SUR 2600. Review syllabus.
• Grades: You can retrieve your assignment marks from the CS CourSys system.
• Policies:
  • All assignments are due at 11:59 p.m. on the day indicated. Late assignments will not be accepted unless there is a documented medical reason.
  • There will be no makeup midterm or final exams. You must be able to write the midterm or final when they are given. The only exceptions are for documented medical reasons or unpredictable and serious personal reasons.
  • All assignments must be done singly by the student, and not in collaboration with others. All sources used must be cited.
  • Students must attain an overall passing grade on the weighted average of exams in the course in order to obtain a clear pass (C- or better).
• Academic Honesty: Academic honesty plays a key role in our efforts to maintain a high standard of academic excellence and integrity. Students are advised that ALL acts of intellectual dishonesty will be handled in accordance with the SFU Academic Honesty and Student Conduct Policies. Students are also encouraged to read the School's policy information page.

Textbooks and Resources

• Text: Database Management Systems, Raghu Ramakrishnan and Johannes Gehrke, McGraw Hill, 2003, ISBN: 9780072465631.
• Helpful book:Database systems the complete book, Hector Garcia-Molina, Jeffrey D.Ullman, Jennifer Widom, Prentice Hall, 2009, 9780131873254.
• SQL Standards: PDF.
• Personal SQL Server Copy: PDF.
• Medical Excuse: PDF Form.