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.
Learning outcomes
- 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 topics
- 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
The following materials are required for this course:
- 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 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 exams@tru.ca 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.
| 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 Information
An Open Learning Faculty Member is available to assist students. Students will receive the necessary contact information at the start of the course.
