Login

• CS SFU
• > Portal
• > Outlines

Computing Science Course Outlines

Course Outline - CMPT 354 - Database Systems I

Information

Calendar Objective/Description

Database Systems I

Instructor's Objectives

Almost all organizations maintain their data using a database management system (DBMS). This course provides an introduction to DBMS. We focus on the most widely used model: the relational data model. Students will become familiar with the design of database applications and use of databases. We study design tools, database modeling and query languages, including the Structured Query Language (SQL).

Prerequisites

see go.sfu.ca

Topics

• Entity-Relationship model
• Relational data model
• Relational algebra and calculus
• Introduction to SQL
• Constraints and triggers
• Database Applications Development
• Normalization
• Introduction to NoSQL

Grading

To be determined in the first week of classes.

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).

Recommended Books

• Fundamentals of Database Systems, Elmasri and Navathe, Pearson, 2016, 9780133970777, 7th. Edition
• Database systems the complete book, Hector Garcia-Molina, Jeffrey D.Ullman, Jennifer Widom, Prentice Hall, 2009, 9780131873254, 2nd Edition
• Database Systems: An Application-Oriented Approach, Michael Kifer, Arthur Berstein, Philip M. Lewis, Addison Wesley, 2005, 9780321268457, The complete version

Academic Honesty Statement

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 ( http://www.sfu.ca/policies/gazette/student.html ).