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
- 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
- Identify and use components of an Object Relational Database Management System.
- 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:
- Connolly, T., & Begg, C. (2015). Database systems: A practical approach to design,
implementation, and management (6th ed.). Pearson Education.
Type: Textbook ISBN:
Please be aware that should your course have a final exam, you are responsible for the fee to the online proctoring service, ProctorU, or to the in-person approved Testing Centre. Please contact email@example.com with any questions about this.
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.
|Assignment 1: Background and Concepts
|Assignment 2: Rational Model and Languages
|Assignment 3: Structures Query Language (SQL)
|Assignment 4: Database Analysis and Design
|Assignment 5: Database Methodology
|Assignment 6: Object-Relational and Object-Oriented DBMSs
|Final Exam (mandatory)
Open Learning Faculty Member Information
An Open Learning Faculty Member is available to assist students. Students will receive the necessary contact information at the start of the course.