COMP 3611: Database Systems

Students are introduced to the database concepts. Students review the underlying data structures that make up databases. Students learn database design techniques using both the Entity Relationship model as well as an object oriented approach to designing database systems. Students study the relational database model and data normalization as they design and implement a case study project. Students also learn data description language, data manipulation language (updates, queries, reports), and data integrity. Students complete a case study work using a relevant and current relational database management system, database management system, software product.

Objectives

  • Identify major components in a typical database environment.
  • Use the database development process within the Systems Development Life Cycle.
  • Logically and physically design multiple table relational databases (using a CASE tool).
  • Understand and perform normalization of a database.
  • Define and verify referential integrity in declarative and procedural ways.
  • Effectively use Structured Query Language (SQL)
  • Understand and use major components of MS Access and major database management systems such as Oracle and SQL Server.
  • Design a simple 00 model for a small database (using Unified Modeling Language standard).
  • Identify and use components of an Object Relational Database Management System.

Course outline

  • Module 0: Preliminaries, Getting Started
  • Module 1: Background and Concepts
  • Module 2: Relational Model and Languages
  • Module 3: Structured Query Language (SQL)
  • Module 4: Database Analysis and Design
  • Module 5: Database Methodology
  • Module 6: Object-Relational and Object-Oriented DBMSs

Required text and materials

Students will receive the following:

  1. Connolly, T., & Begg, C. (2015). Database systems: A practical approach to design, implementation, and management (6th ed.). Pearson Education.
    Type: Textbook ISBN: 978-0-13-294326-0.

Assessments

Please be aware that due to COVID-19 safety guidelines all in-person exams have been suspended. As such, all final exams are currently being delivered through ProctorU, which has an approximate fee of $35 involved. There will be more information in your course shell, on how to apply, if your course has a final exam.

To successfully complete this course, students must achieve a passing grade of 50% or higher on the overall course, and 50% or higher on the final mandatory exam.

Quiz 1 2%
Assignment 1: Background and Concepts 4%
Quiz 2 2%
Assignment 2: Rational Model and Languages 6%
Quiz 3 2%
Assignment 3: Structures Query Language (SQL) 10%
Quiz 4 2%
Assignment 4: Database Analysis and Design 9%
Quiz 5 2%
Assignment 5: Database Methodology 9%
Quiz 6 2%
Assignment 6: Object-Relational and Object-Oriented DBMSs 5%
Final Exam (mandatory) 45%
Total 100%

Open Learning Faculty Member

An Open Learning Faculty Member is available to assist students. Primary communication is through the Learning Environment's "Mail" tool or by phone. Students will receive the necessary contact information at the start of the course.

Search To Top