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

CPE 308: Database Systems & Software Engineering Principles

Relational data modeling, SQL, normalization (1NF-BCNF), ACID transactions, Agile/Scrum, UML, TDD, and CI/CD.

Instructor
Created by PAMCET Learning Team
intermediate2 - 4 weeksEnglish

Course Overview

Relational data modeling, SQL, normalization (1NF-BCNF), ACID transactions, Agile/Scrum, UML, TDD, and CI/CD. Curriculum Structure & Core Modules: • 1. Database System Architecture: Data Abstraction, Schemas, and the Relational Model • 2. Conceptual Database Design:...

What You'll Learn

  • Model complex engineering data requirements into normalized Entity-Relationship (ER) schemas.
  • Write advanced SQL queries including multi-table joins, subqueries, aggregation, and index optimization.
  • Analyze relational normalization theory up to Boyce-Codd Normal Form (BCNF) to eliminate data anomalies.
  • Apply Agile software engineering methodologies, Scrum sprint cadences, and user story estimations.
  • Construct UML diagrams (Class, Sequence, State Machine) and implement automated CI/CD testing pipelines.

Requirements

  • Completion of CPE 212.

Degree Programme Curriculum Context

This course is a curriculum unit of the Bachelor of Engineering (B.Eng.) in Computer 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~3 min read

Database System Architecture: Data Abstraction, Schemas, and the Relational Model: Theoretical Foundations, Modeling & Architecture

CPE 308 • 300L &b

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

Database System Architecture: Data Abstraction, Schemas, and the Relational Model: Computations, Implementation & Verification

CPE 308 • 300L &b

Module 1 • Subtopic 2•500 characters of authentic academic content
Formative Assessment10 Points • 15 Mins

Chapter 1 Formative Assessment: Database System Architecture: Data Abstraction, Schemas, and

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

Rigorous formative competency assessment for Chapter 1: Database System Architecture: Data Abstraction, Schemas, and the Relational Model. Aligned with NUC CCMAS and COREN OBE standards.

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

Conceptual Database Design: Entity-Relationship (ER) Modeling and Enhanced ER Diagrams: Theoretical Foundations, Modeling & Architecture

CPE 308 • 300L &b

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

Conceptual Database Design: Entity-Relationship (ER) Modeling and Enhanced ER Diagrams: Computations, Implementation & Verification

CPE 308 • 300L &b

Module 2 • Subtopic 2•500 characters of authentic academic content
Formative Assessment10 Points • 15 Mins

Chapter 2 Formative Assessment: Conceptual Database Design: Entity-Relationship (ER) Modelin

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

Rigorous formative competency assessment for Chapter 2: Conceptual Database Design: Entity-Relationship (ER) Modeling and Enhanced ER Diagrams. Aligned with NUC CCMAS and COREN OBE standards.

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

Relational Algebra Operations and Structured Query Language (SQL): DDL, DML, and DCL: Theoretical Foundations, Modeling & Architecture

CPE 308 • 300L &b

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

Relational Algebra Operations and Structured Query Language (SQL): DDL, DML, and DCL: Computations, Implementation & Verification

CPE 308 • 300L &b

Module 3 • Subtopic 2•500 characters of authentic academic content
Formative Assessment10 Points • 15 Mins

Chapter 3 Formative Assessment: Relational Algebra Operations and Structured Query Language

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

Rigorous formative competency assessment for Chapter 3: Relational Algebra Operations and Structured Query Language (SQL): DDL, DML, and DCL. Aligned with NUC CCMAS and COREN OBE standards.

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

Advanced SQL: Multi-Table Joins, Aggregation, Views, Triggers, and Stored Procedures: Theoretical Foundations, Modeling & Architecture

CPE 308 • 300L &b

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

Advanced SQL: Multi-Table Joins, Aggregation, Views, Triggers, and Stored Procedures: Computations, Implementation & Verification

CPE 308 • 300L &b

Module 4 • Subtopic 2•500 characters of authentic academic content
Formative Assessment10 Points • 15 Mins

Chapter 4 Formative Assessment: Advanced SQL: Multi-Table Joins, Aggregation, Views, Trigger

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

Rigorous formative competency assessment for Chapter 4: Advanced SQL: Multi-Table Joins, Aggregation, Views, Triggers, and Stored Procedures. Aligned with NUC CCMAS and COREN OBE standards.

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

Relational Database Normalization: Functional Dependencies, 1NF, 2NF, 3NF, and BCNF: Theoretical Foundations, Modeling & Architecture

CPE 308 • 300L &b

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

Relational Database Normalization: Functional Dependencies, 1NF, 2NF, 3NF, and BCNF: Computations, Implementation & Verification

CPE 308 • 300L &b

Module 5 • Subtopic 2•500 characters of authentic academic content
Formative Assessment10 Points • 15 Mins

Chapter 5 Formative Assessment: Relational Database Normalization: Functional Dependencies,

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

Rigorous formative competency assessment for Chapter 5: Relational Database Normalization: Functional Dependencies, 1NF, 2NF, 3NF, and BCNF. Aligned with NUC CCMAS and COREN OBE standards.

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

Transaction Management: ACID Properties, Serializability, Two-Phase Locking, and WAL Logging: Theoretical Foundations, Modeling & Architecture

CPE 308 • 300L &b

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

Transaction Management: ACID Properties, Serializability, Two-Phase Locking, and WAL Logging: Computations, Implementation & Verification

CPE 308 • 300L &b

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

Chapter 6 Formative Assessment: Transaction Management: ACID Properties, Serializability, Tw

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

Rigorous formative competency assessment for Chapter 6: Transaction Management: ACID Properties, Serializability, Two-Phase Locking, and WAL Logging. Aligned with NUC CCMAS and COREN OBE standards.

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

Software Engineering Processes: Waterfall vs Agile, Scrum Ceremonies, and Requirements Engineering: Theoretical Foundations, Modeling & Architecture

CPE 308 • 300L &b

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

Software Engineering Processes: Waterfall vs Agile, Scrum Ceremonies, and Requirements Engineering: Computations, Implementation & Verification

CPE 308 • 300L &b

Module 7 • Subtopic 2•500 characters of authentic academic content
Formative Assessment10 Points • 15 Mins

Chapter 7 Formative Assessment: Software Engineering Processes: Waterfall vs Agile, Scrum Ce

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

Rigorous formative competency assessment for Chapter 7: Software Engineering Processes: Waterfall vs Agile, Scrum Ceremonies, and Requirements Engineering. Aligned with NUC CCMAS and COREN OBE standards.

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

UML Modeling, Software Architecture Patterns, Test-Driven Development (TDD), and CI/CD Pipelines: Theoretical Foundations, Modeling & Architecture

CPE 308 • 300L &b

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

UML Modeling, Software Architecture Patterns, Test-Driven Development (TDD), and CI/CD Pipelines: Computations, Implementation & Verification

CPE 308 • 300L &b

Module 8 • Subtopic 2•500 characters of authentic academic content
Formative Assessment10 Points • 15 Mins

Chapter 8 Formative Assessment: UML Modeling, Software Architecture Patterns, Test-Driven De

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

Rigorous formative competency assessment for Chapter 8: UML Modeling, Software Architecture Patterns, Test-Driven Development (TDD), and CI/CD Pipelines. Aligned with NUC CCMAS and COREN OBE standards.

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
CPE 308: Database Systems & Software Engineering Principles
Free$24.99100% Off
Certificate available separately for $7 after completion

Course Includes

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

Download Syllabus & Study Guide

Receive the full lecture syllabus, reading list, and milestone schedule for CPE 308: Database Systems & Software Engineering Principles.

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