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