Skip to main content
B.Eng DegreeFaculty of Faculty of Engineering & TechnologySoftware Engineering

SWE 205: Database Systems & Relational Data Engineering

Theory and practice of relational database management systems (RDBMS). Relational algebra, SQL (DDL, DML, DQL), entity-relationship (ER) modeling, functional dependencies, schema normalization (1NF through BCNF), storage engines, B-tree indexing, que...

Instructor
Created by PAMCET Learning Team
beginner2 - 4 weeksEnglish

Course Overview

Theory and practice of relational database management systems (RDBMS). Relational algebra, SQL (DDL, DML, DQL), entity-relationship (ER) modeling, functional dependencies, schema normalization (1NF through BCNF), storage engines, B-tree indexing, que... Curriculum Structure &...

What You'll Learn

  • Design normalized relational database schemas from complex enterprise domain models.
  • Normalize relational tables up to Boyce-Codd Normal Form (BCNF) eliminating insertion, update, and deletion anomalies.
  • Write complex SQL queries involving multi-table joins, subqueries, aggregations, and window functions.
  • Analyze query execution plans (EXPLAIN) to identify index scans, sequential scans, and join bottlenecks.
  • Implement concurrent database transactions adhering to ACID guarantees and appropriate isolation levels.

Requirements

  • SWE 103
  • SWE 107

Degree Programme Curriculum Context

This course is a curriculum unit of the Bachelor of Engineering (B.Eng.) in Software Engineering degree framework in Nigeria.

Earn Your Certificate

Showcase your skills with a certificate! Complete the course, submit your project, and earn your certificate. Here's a sample of what you'll receive to show off your accomplishments.

course-certificate
Lecture Board & Syllabus

Course Curriculum

Browse complete theoretical foundations, worked calculations, laboratory protocols, and board assessment questions under each topic.

Launch Course Reader →
8 Chapters
•
16 Lecture
•
24h
Subtopic 1Document LectureOpen Access~19 min read

Database Systems Architecture: The Three-Schema Hierarchy: Theoretical Foundations, System Architecture & Subtopic Deep-Dive

SWE 205 • 200L • Software Systems Infrastructure Chapter 1: Database Systems Architecture: The Three-Schema Hierarchy — Theoretical Foundations, System Architecture & Analytical Modeling Course: Database Systems & Relational Data Engineering Curriculum: CCMAS-SWE-205 Accreditation: COREN-SWE-DAT-01 Benchmark: IEEE/ACM CS2023-IM-REL 1. Executive Overview & Theoretical Fo...

Module 1 • Subtopic 1•15,791 characters of authentic academic content
Subtopic 2Document LectureOpen Access~8 min read

Database Systems Architecture: The Three-Schema Hierarchy: Worked Engineering Problems, Production Code & Simulation Protocols

SWE 205 • 200L • Software Systems Infrastructure Chapter 1: Database Systems Architecture: The Three-Schema Hierarchy — Applied Engineering Computation, Production Systems & Verification Course: Database Systems & Relational Data Engineering Curriculum: CCMAS-SWE-205 Accreditation: COREN-SWE-DAT-01 Standard: IEEE / ACM SE Practice Guidelines 1. Laboratory & Computationa...

Module 1 • Subtopic 2•6,655 characters of authentic academic content
Formative Assessment10 Points • 15 Mins

Chapter 1: Database Systems Architecture: The Three-Schema Hierarchy — Formative Engineering Quiz

Assessment Protocol:10 Total Points•70% Passing Threshold•15 Mins Time Limit•Bloom's Taxonomy: Analyze & Evaluate

Rigorous formative evaluation assessing theoretical knowledge, mathematical formulations, and engineering principles for Database Systems Architecture: The Three-Schema Hierarchy.

Module 1 • Formative Assessment
Subtopic 1Document LectureOpen Access~18 min read

The Relational Model: Relations, Tuples, Keys & Relational Algebra: Theoretical Foundations, System Architecture & Subtopic Deep-Dive

SWE 205 • 200L • Software Systems Infrastructure Chapter 2: The Relational Model: Relations, Tuples, Keys & Relational Algebra — Theoretical Foundations, System Architecture & Analytical Modeling Course: Database Systems & Relational Data Engineering Curriculum: CCMAS-SWE-205 Accreditation: COREN-SWE-DAT-01 Benchmark: IEEE/ACM CS2023-IM-REL 1. Executive Overview & T...

Module 2 • Subtopic 1•14,504 characters of authentic academic content
Subtopic 2Document LectureOpen Access~8 min read

The Relational Model: Relations, Tuples, Keys & Relational Algebra: Worked Engineering Problems, Production Code & Simulation Protocols

SWE 205 • 200L • Software Systems Infrastructure Chapter 2: The Relational Model: Relations, Tuples, Keys & Relational Algebra — Applied Engineering Computation, Production Systems & Verification Course: Database Systems & Relational Data Engineering Curriculum: CCMAS-SWE-205 Accreditation: COREN-SWE-DAT-01 Standard: IEEE / ACM SE Practice Guidelines 1. Laboratory &...

Module 2 • Subtopic 2•6,703 characters of authentic academic content
Formative Assessment10 Points • 15 Mins

Chapter 2: The Relational Model: Relations, Tuples, Keys & Relational Algebra — Formative Engineering Quiz

Assessment Protocol:10 Total Points•70% Passing Threshold•15 Mins Time Limit•Bloom's Taxonomy: Analyze & Evaluate

Rigorous formative evaluation assessing theoretical knowledge, mathematical formulations, and engineering principles for The Relational Model: Relations, Tuples, Keys & Relational Algebra.

Module 2 • Formative Assessment
Subtopic 1Document LectureOpen Access~18 min read

Advanced SQL: Joins, Aggregations, Subqueries, CTEs & Window Functions: Theoretical Foundations, System Architecture & Subtopic Deep-Dive

SWE 205 • 200L • Software Systems Infrastructure Chapter 3: Advanced SQL: Joins, Aggregations, Subqueries, CTEs & Window Functions — Theoretical Foundations, System Architecture & Analytical Modeling Course: Database Systems & Relational Data Engineering Curriculum: CCMAS-SWE-205 Accreditation: COREN-SWE-DAT-01 Benchmark: IEEE/ACM CS2023-IM-REL 1. Executive Overview &am...

Module 3 • Subtopic 1•14,500 characters of authentic academic content
Subtopic 2Document LectureOpen Access~8 min read

Advanced SQL: Joins, Aggregations, Subqueries, CTEs & Window Functions: Worked Engineering Problems, Production Code & Simulation Protocols

SWE 205 • 200L • Software Systems Infrastructure Chapter 3: Advanced SQL: Joins, Aggregations, Subqueries, CTEs & Window Functions — Applied Engineering Computation, Production Systems & Verification Course: Database Systems & Relational Data Engineering Curriculum: CCMAS-SWE-205 Accreditation: COREN-SWE-DAT-01 Standard: IEEE / ACM SE Practice Guidelines 1. Laboratory &...

Module 3 • Subtopic 2•6,719 characters of authentic academic content
Formative Assessment10 Points • 15 Mins

Chapter 3: Advanced SQL: Joins, Aggregations, Subqueries, CTEs & Window Functions — Formative Engineering Quiz

Assessment Protocol:10 Total Points•70% Passing Threshold•15 Mins Time Limit•Bloom's Taxonomy: Analyze & Evaluate

Rigorous formative evaluation assessing theoretical knowledge, mathematical formulations, and engineering principles for Advanced SQL: Joins, Aggregations, Subqueries, CTEs & Window Functions.

Module 3 • Formative Assessment
Subtopic 1Document LectureOpen Access~19 min read

Conceptual Database Design: Entity-Relationship (ER) & Enhanced ER Modeling: Theoretical Foundations, System Architecture & Subtopic Deep-Dive

SWE 205 • 200L • Software Systems Infrastructure Chapter 4: Conceptual Database Design: Entity-Relationship (ER) & Enhanced ER Modeling — Theoretical Foundations, System Architecture & Analytical Modeling Course: Database Systems & Relational Data Engineering Curriculum: CCMAS-SWE-205 Accreditation: COREN-SWE-DAT-01 Benchmark: IEEE/ACM CS2023-IM-REL 1. Executive Overvie...

Module 4 • Subtopic 1•15,813 characters of authentic academic content
Subtopic 2Document LectureOpen Access~8 min read

Conceptual Database Design: Entity-Relationship (ER) & Enhanced ER Modeling: Worked Engineering Problems, Production Code & Simulation Protocols

SWE 205 • 200L • Software Systems Infrastructure Chapter 4: Conceptual Database Design: Entity-Relationship (ER) & Enhanced ER Modeling — Applied Engineering Computation, Production Systems & Verification Course: Database Systems & Relational Data Engineering Curriculum: CCMAS-SWE-205 Accreditation: COREN-SWE-DAT-01 Standard: IEEE / ACM SE Practice Guidelines 1. Laborat...

Module 4 • Subtopic 2•6,739 characters of authentic academic content
Formative Assessment10 Points • 15 Mins

Chapter 4: Conceptual Database Design: Entity-Relationship (ER) & Enhanced ER Modeling — Formative Engineering Quiz

Assessment Protocol:10 Total Points•70% Passing Threshold•15 Mins Time Limit•Bloom's Taxonomy: Analyze & Evaluate

Rigorous formative evaluation assessing theoretical knowledge, mathematical formulations, and engineering principles for Conceptual Database Design: Entity-Relationship (ER) & Enhanced ER Modeling.

Module 4 • Formative Assessment
Subtopic 1Document LectureOpen Access~18 min read

Functional Dependencies, Normalization (1NF, 2NF, 3NF, BCNF) & Lossless Decompositions: Theoretical Foundations, System Architecture & Subtopic Deep-Dive

SWE 205 • 200L • Software Systems Infrastructure Chapter 5: Functional Dependencies, Normalization (1NF, 2NF, 3NF, BCNF) & Lossless Decompositions — Theoretical Foundations, System Architecture & Analytical Modeling Course: Database Systems & Relational Data Engineering Curriculum: CCMAS-SWE-205 Accreditation: COREN-SWE-DAT-01 Benchmark: IEEE/ACM CS2023-IM-REL 1. Execut...

Module 5 • Subtopic 1•14,626 characters of authentic academic content
Subtopic 2Document LectureOpen Access~8 min read

Functional Dependencies, Normalization (1NF, 2NF, 3NF, BCNF) & Lossless Decompositions: Worked Engineering Problems, Production Code & Simulation Protocols

SWE 205 • 200L • Software Systems Infrastructure Chapter 5: Functional Dependencies, Normalization (1NF, 2NF, 3NF, BCNF) & Lossless Decompositions — Applied Engineering Computation, Production Systems & Verification Course: Database Systems & Relational Data Engineering Curriculum: CCMAS-SWE-205 Accreditation: COREN-SWE-DAT-01 Standard: IEEE / ACM SE Practice Guidelines...

Module 5 • Subtopic 2•6,783 characters of authentic academic content
Formative Assessment10 Points • 15 Mins

Chapter 5: Functional Dependencies, Normalization (1NF, 2NF, 3NF, BCNF) & Lossless Decompositions — Formative Engineering Quiz

Assessment Protocol:10 Total Points•70% Passing Threshold•15 Mins Time Limit•Bloom's Taxonomy: Analyze & Evaluate

Rigorous formative evaluation assessing theoretical knowledge, mathematical formulations, and engineering principles for Functional Dependencies, Normalization (1NF, 2NF, 3NF, BCNF) & Lossless Decompositions.

Module 5 • Formative Assessment
Subtopic 1Document LectureOpen Access~18 min read

Storage Internals, B-Trees, Hash Indices & Query Execution Plans: Theoretical Foundations, System Architecture & Subtopic Deep-Dive

SWE 205 • 200L • Software Systems Infrastructure Chapter 6: Storage Internals, B-Trees, Hash Indices & Query Execution Plans — Theoretical Foundations, System Architecture & Analytical Modeling Course: Database Systems & Relational Data Engineering Curriculum: CCMAS-SWE-205 Accreditation: COREN-SWE-DAT-01 Benchmark: IEEE/ACM CS2023-IM-REL 1. Executive Overview & The...

Module 6 • Subtopic 1•14,580 characters of authentic academic content
Subtopic 2Document LectureOpen Access~8 min read

Storage Internals, B-Trees, Hash Indices & Query Execution Plans: Worked Engineering Problems, Production Code & Simulation Protocols

SWE 205 • 200L • Software Systems Infrastructure Chapter 6: Storage Internals, B-Trees, Hash Indices & Query Execution Plans — Applied Engineering Computation, Production Systems & Verification Course: Database Systems & Relational Data Engineering Curriculum: CCMAS-SWE-205 Accreditation: COREN-SWE-DAT-01 Standard: IEEE / ACM SE Practice Guidelines 1. Laboratory & C...

Module 6 • Subtopic 2•6,695 characters of authentic academic content
Formative Assessment10 Points • 15 Mins

Chapter 6: Storage Internals, B-Trees, Hash Indices & Query Execution Plans — Formative Engineering Quiz

Assessment Protocol:10 Total Points•70% Passing Threshold•15 Mins Time Limit•Bloom's Taxonomy: Analyze & Evaluate

Rigorous formative evaluation assessing theoretical knowledge, mathematical formulations, and engineering principles for Storage Internals, B-Trees, Hash Indices & Query Execution Plans.

Module 6 • Formative Assessment
Subtopic 1Document LectureOpen Access~18 min read

Transaction Management: ACID Properties, Concurrency Control & Isolation Levels: Theoretical Foundations, System Architecture & Subtopic Deep-Dive

SWE 205 • 200L • Software Systems Infrastructure Chapter 7: Transaction Management: ACID Properties, Concurrency Control & Isolation Levels — Theoretical Foundations, System Architecture & Analytical Modeling Course: Database Systems & Relational Data Engineering Curriculum: CCMAS-SWE-205 Accreditation: COREN-SWE-DAT-01 Benchmark: IEEE/ACM CS2023-IM-REL 1. Executive Ove...

Module 7 • Subtopic 1•14,721 characters of authentic academic content
Subtopic 2Document LectureOpen Access~8 min read

Transaction Management: ACID Properties, Concurrency Control & Isolation Levels: Worked Engineering Problems, Production Code & Simulation Protocols

SWE 205 • 200L • Software Systems Infrastructure Chapter 7: Transaction Management: ACID Properties, Concurrency Control & Isolation Levels — Applied Engineering Computation, Production Systems & Verification Course: Database Systems & Relational Data Engineering Curriculum: CCMAS-SWE-205 Accreditation: COREN-SWE-DAT-01 Standard: IEEE / ACM SE Practice Guidelines 1. Lab...

Module 7 • Subtopic 2•6,755 characters of authentic academic content
Formative Assessment10 Points • 15 Mins

Chapter 7: Transaction Management: ACID Properties, Concurrency Control & Isolation Levels — Formative Engineering Quiz

Assessment Protocol:10 Total Points•70% Passing Threshold•15 Mins Time Limit•Bloom's Taxonomy: Analyze & Evaluate

Rigorous formative evaluation assessing theoretical knowledge, mathematical formulations, and engineering principles for Transaction Management: ACID Properties, Concurrency Control & Isolation Levels.

Module 7 • Formative Assessment
Subtopic 1Document LectureOpen Access~19 min read

Write-Ahead Logging (WAL), Crash Recovery & Database Security Controls: Theoretical Foundations, System Architecture & Subtopic Deep-Dive

SWE 205 • 200L • Software Systems Infrastructure Chapter 8: Write-Ahead Logging (WAL), Crash Recovery & Database Security Controls — Theoretical Foundations, System Architecture & Analytical Modeling Course: Database Systems & Relational Data Engineering Curriculum: CCMAS-SWE-205 Accreditation: COREN-SWE-DAT-01 Benchmark: IEEE/ACM CS2023-IM-REL 1. Executive Overview &am...

Module 8 • Subtopic 1•15,779 characters of authentic academic content
Subtopic 2Document LectureOpen Access~8 min read

Write-Ahead Logging (WAL), Crash Recovery & Database Security Controls: Worked Engineering Problems, Production Code & Simulation Protocols

SWE 205 • 200L • Software Systems Infrastructure Chapter 8: Write-Ahead Logging (WAL), Crash Recovery & Database Security Controls — Applied Engineering Computation, Production Systems & Verification Course: Database Systems & Relational Data Engineering Curriculum: CCMAS-SWE-205 Accreditation: COREN-SWE-DAT-01 Standard: IEEE / ACM SE Practice Guidelines 1. Laboratory &...

Module 8 • Subtopic 2•6,719 characters of authentic academic content
Formative Assessment10 Points • 15 Mins

Chapter 8: Write-Ahead Logging (WAL), Crash Recovery & Database Security Controls — Formative Engineering Quiz

Assessment Protocol:10 Total Points•70% Passing Threshold•15 Mins Time Limit•Bloom's Taxonomy: Analyze & Evaluate

Rigorous formative evaluation assessing theoretical knowledge, mathematical formulations, and engineering principles for Write-Ahead Logging (WAL), Crash Recovery & Database Security Controls.

Module 8 • Formative Assessment

Instructor

PAMCET Learning Team

PAMCET Learning Team

Institutional Course Curation · PAMCET

The PAMCET Learning Team is the institutional curriculum and content group behind course publishing on this platform. PAMCET (Professional and Academic Management Centre for Education and Training) is operated by Digitpen Hub Ltd, a company registered in Lagos, Nigeria. Courses credited to the PAMCET Learning Team are structured, organized, and published centrally by the platform rather than authored by a single named individual instructor — each course's syllabus, learning outcomes, and content are reviewed before publication under this institutional account. For questions about a specific course or to report a content issue, please use the platform's Help & Support or Contact Us pages.

Qualifications:

PAMCET Learning Team — Institutional Course Curation, Digitpen Hub Ltd

My Skills:

  • Curriculum Curation
  • Course Content Review
  • Learning Outcome Design
  • Course Publishing & Quality Assurance
  • Platform Content Operations

Reviews

No reviews available
SWE 205: Database Systems & Relational Data Engineering
Free$24.99100% Off
Certificate available separately for $7 after completion

Course Includes

8 Chapters
16 Lectures
2 - 4 weeks
Skill Level beginner
Taught in English
Lifetime Access
Certification of Completion
Category: University - Software Engineering
Share On

Download Syllabus & Study Guide

Receive the full lecture syllabus, reading list, and milestone schedule for SWE 205: Database Systems & Relational Data Engineering.

By submitting, you agree to receive educational updates. You can unsubscribe anytime. Read our Privacy Policy.

SWE 205: Database Systems & Relational Data Engineering | PAMCET University — B.Eng | PAMCET