Course Outline - CMPT 354 - Database Systems I

Information

Subject

Catalog Number

Section

Semester

Title

Instructor(s)

Campus

CMPT

354

D100

2022 Fall (1227)

Database Systems I

Ke Wang

Burnaby Mountain Campus

Calendar Objective/Description

Database Systems I

Instructor's Objectives

This first database course will provide an introduction to DBMS. We will focus the most widely used relational data model, and introduce several core concepts in relational data models. The emphasis of this course is on the DESIGN of database applications from the database administer's point of view, and the USE of databases from the database user's point of view.

Prerequisites

see go.sfu.ca

Topics

An introduction to Database Systems. .
Entity-Relationship Model.
Relational Model.
Integrity Constraints.
Relational Database Design
Query Languages (SQL).
Applications

Grading

Two assignments (20%), SQL project (15%), class attendance (5%), one midterm (20%) and one final (40%).

Required Books

Database Management Systems, third edition., Raghu Ramakrishnan/Johannes Gehrke, McGraw Hill, 2003, 9780072465631

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