Simon Fraser University
Engaging the World

Course Outlines

Summer 2019 - CMPT 354 D100

Database Systems I (3)

Class Number: 4800

Delivery Method: In Person

Overview

  • Course Times + Location:

    May 6 – Aug 2, 2019: Tue, 1:30–2:20 p.m.
    Burnaby

    May 6 – Aug 2, 2019: Thu, 12:30–2:20 p.m.
    Burnaby

  • Exam Times + Location:

    Aug 12, 2019
    Mon, 12:00–3:00 p.m.
    Burnaby

  • Prerequisites:

    CMPT 225, and (MACM 101 or (ENSC 251 and ENSC 252)).

Description

CALENDAR DESCRIPTION:

Logical representations of data records. Data models. Studies of some popular file and database systems. Document retrieval. Other related issues such as database administration, data dictionary and security.

COURSE DETAILS:

Introduction to the principles, concepts, approaches, tools, and methodology of database design and implementation, and Database Management Systems. Covers theoretical foundations and practical languages for relational databases, their implementation, use and optimization.

Topics

  • Introduction
  • Relational Data Model
  • Relational Algebra
  • SQL
  • Constraints and Triggers
  • Database Applications
  • Normalization
  • NoSQL
  • Advanced Topics

Grading

NOTES:

Assignments (20%) Quizzes (10%) Midterm (20%) Final (50%)

Materials

RECOMMENDED READING:

  • A First Course in Database Systems, Ullman, Widom, Pearson, 2007, 9780136006374, Edition
  • Database Management Systems, Raghu Ramakrishnan and Johannes Gehrke, McGraw-Hill, 2003, 9780072465631, 3rd Edition
  • Database Systems: The Complete Book , Hector Garcia-Molina, Jeffrey D. Ullman, Jennifer Widom, Prentice Hall , 2009, 9780131873254, 2nd Edition

Registrar Notes:

SFU’s Academic Integrity web site http://www.sfu.ca/students/academicintegrity.html is filled with information on what is meant by academic dishonesty, where you can find resources to help with your studies and the consequences of cheating.  Check out the site for more information and videos that help explain the issues in plain English.

Each student is responsible for his or her conduct as it affects the University community.  Academic dishonesty, in whatever form, is ultimately destructive of the values of the University. Furthermore, it is unfair and discouraging to the majority of students who pursue their studies honestly. Scholarly integrity is required of all members of the University. http://www.sfu.ca/policies/gazette/student/s10-01.html

ACADEMIC INTEGRITY: YOUR WORK, YOUR SUCCESS