COMP 3611 - Database Systems

Course Description

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

Students are responsible for purchasing the required materials on their own:

• Connolly, T., & Begg, C. (2015). Database Systems: A Practical Approach to Design, Implementation, and Management (6th ed.). Pearson Education.
  Type: Textbook. ISBN: 9780132943260 / 9780133869750

Note: This item can be purchased directly from the following link.

Assessments

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.

Recommended requisite(s)

• COMP 2230; or COMP 2231

Exclusions

• COMP 3610