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.
CPE 308: Database Systems & Software Engineering Principles
Relational data modeling, SQL, normalization (1NF-BCNF), ACID transactions, Agile/Scrum, UML, TDD, and CI/CD.
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 Curriculum
Browse complete theoretical foundations, worked calculations, laboratory protocols, and board assessment questions under each topic.
Database System Architecture: Data Abstraction, Schemas, and the Relational Model: Theoretical Foundations, Modeling & Architecture
CPE 308 • 300L &b
Database System Architecture: Data Abstraction, Schemas, and the Relational Model: Computations, Implementation & Verification
CPE 308 • 300L &b
Chapter 1 Formative Assessment: Database System Architecture: Data Abstraction, Schemas, and
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.
Conceptual Database Design: Entity-Relationship (ER) Modeling and Enhanced ER Diagrams: Theoretical Foundations, Modeling & Architecture
CPE 308 • 300L &b
Conceptual Database Design: Entity-Relationship (ER) Modeling and Enhanced ER Diagrams: Computations, Implementation & Verification
CPE 308 • 300L &b
Chapter 2 Formative Assessment: Conceptual Database Design: Entity-Relationship (ER) Modelin
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.
Relational Algebra Operations and Structured Query Language (SQL): DDL, DML, and DCL: Theoretical Foundations, Modeling & Architecture
CPE 308 • 300L &b
Relational Algebra Operations and Structured Query Language (SQL): DDL, DML, and DCL: Computations, Implementation & Verification
CPE 308 • 300L &b
Chapter 3 Formative Assessment: Relational Algebra Operations and Structured Query Language
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.
Advanced SQL: Multi-Table Joins, Aggregation, Views, Triggers, and Stored Procedures: Theoretical Foundations, Modeling & Architecture
CPE 308 • 300L &b
Advanced SQL: Multi-Table Joins, Aggregation, Views, Triggers, and Stored Procedures: Computations, Implementation & Verification
CPE 308 • 300L &b
Chapter 4 Formative Assessment: Advanced SQL: Multi-Table Joins, Aggregation, Views, Trigger
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.
Relational Database Normalization: Functional Dependencies, 1NF, 2NF, 3NF, and BCNF: Theoretical Foundations, Modeling & Architecture
CPE 308 • 300L &b
Relational Database Normalization: Functional Dependencies, 1NF, 2NF, 3NF, and BCNF: Computations, Implementation & Verification
CPE 308 • 300L &b
Chapter 5 Formative Assessment: Relational Database Normalization: Functional Dependencies,
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.
Transaction Management: ACID Properties, Serializability, Two-Phase Locking, and WAL Logging: Theoretical Foundations, Modeling & Architecture
CPE 308 • 300L &b
Transaction Management: ACID Properties, Serializability, Two-Phase Locking, and WAL Logging: Computations, Implementation & Verification
CPE 308 • 300L &b
Chapter 6 Formative Assessment: Transaction Management: ACID Properties, Serializability, Tw
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.
Software Engineering Processes: Waterfall vs Agile, Scrum Ceremonies, and Requirements Engineering: Theoretical Foundations, Modeling & Architecture
CPE 308 • 300L &b
Software Engineering Processes: Waterfall vs Agile, Scrum Ceremonies, and Requirements Engineering: Computations, Implementation & Verification
CPE 308 • 300L &b
Chapter 7 Formative Assessment: Software Engineering Processes: Waterfall vs Agile, Scrum Ce
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.
UML Modeling, Software Architecture Patterns, Test-Driven Development (TDD), and CI/CD Pipelines: Theoretical Foundations, Modeling & Architecture
CPE 308 • 300L &b
UML Modeling, Software Architecture Patterns, Test-Driven Development (TDD), and CI/CD Pipelines: Computations, Implementation & Verification
CPE 308 • 300L &b
Chapter 8 Formative Assessment: UML Modeling, Software Architecture Patterns, Test-Driven De
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.
Academic Ecosystem & Connected Pathways
Deepen your studies across connected learning pathways in the PAMCET academic network:
Instructor
PAMCET Learning Team
Institutional Course Curation · PAMCET
Qualifications:
PAMCET Learning Team — Institutional Course Curation, Digitpen Hub LtdMy Skills:
- Curriculum Curation
- Course Content Review
- Learning Outcome Design
- Course Publishing & Quality Assurance
- Platform Content Operations
Reviews
Course Includes
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.

