Skip to main content
B.Sc. DegreeFaculty of Faculty of Computing & Information TechnologyComputer Science

Database Systems

Master Database Systems in University - Computer Science with this structured course, covering 8 modules and practice assessments.

Instructor
Created by PAMCET Learning Team
intermediate2 - 4 weeksEnglish

Course Overview

Master Database Systems in University - Computer Science with this structured course, covering 8 modules and practice assessments. Curriculum Structure & Core Modules: • 1. Database System Concepts, Architecture, Three-Schema Architecture & Data Independence • 2. Data Modeling:...

What You'll Learn

  • Understand and apply the principles of Database System Architecture
  • Work confidently through Relational Data Model and its practical applications
  • Analyse real-world scenarios involving Entity Relationship Modelling
  • Develop applied skills in Normalisation
  • Critically evaluate approaches to SQL — Queries and Joins

Requirements

  • A foundational understanding of University - Computer Science concepts, from an introductory course or equivalent experience
  • A computer, tablet or smartphone with a stable internet connection
  • Willingness to commit regular study time to complete lessons, quizzes and assignments

Degree Programme Curriculum Context

This course is a curriculum unit of the B.Sc. Computer Science 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
•
24 Lecture
•
18h
Subtopic 1Document LectureOpen Access

Database Systems vs File-Processing Systems, DBMS Components & Architecture

Sign in or enroll to access the full lecture notes and interactive reader.

Module 1 • Subtopic 1
Subtopic 2Document Lecture

ANSI/SPARC Three-Schema Architecture, Logical & Physical Data Independence

Sign in or enroll to access the full lecture notes and interactive reader.

Module 1 • Subtopic 2
Subtopic 3Document Lecture

DBMS Classification, Data Models, Data Dictionaries & System Catalogs

Sign in or enroll to access the full lecture notes and interactive reader.

Module 1 • Subtopic 3
Subtopic 1Document Lecture

Conceptual Data Modeling: Entities, Attributes, Relationships & Keys

Sign in or enroll to access the full lecture notes and interactive reader.

Module 2 • Subtopic 1
Subtopic 2Document Lecture

Structural Constraints: Cardinality Ratios, Participation Constraints & Weak Entities

Sign in or enroll to access the full lecture notes and interactive reader.

Module 2 • Subtopic 2
Subtopic 3Document Lecture

Enhanced ER (EER) Modeling: Specialization, Generalization, Aggregation & Category Unions

Sign in or enroll to access the full lecture notes and interactive reader.

Module 2 • Subtopic 3
Subtopic 1Document Lecture

The Relational Model: Domains, Attributes, Tuples, Relations & Integrity Constraints

Sign in or enroll to access the full lecture notes and interactive reader.

Module 3 • Subtopic 1
Subtopic 2Document Lecture

Formal Relational Algebra: Select, Project, Set Operations, Cartesian Product & Joins

Sign in or enroll to access the full lecture notes and interactive reader.

Module 3 • Subtopic 2
Subtopic 3Document Lecture

ER-to-Relational Mapping Algorithms & Relational Calculus (Tuple vs Domain Calculus)

Sign in or enroll to access the full lecture notes and interactive reader.

Module 3 • Subtopic 3
Formative Assessment10 Points • 15 Mins

Mid-Course Progress Assessment

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

Test your knowledge of Normalisation

Module 4 • Formative Assessment
Subtopic 2Document Lecture

SQL Data Definition Language (DDL): Schema Creation, Constraints, Alteration & Integrity

Sign in or enroll to access the full lecture notes and interactive reader.

Module 4 • Subtopic 2
Subtopic 3Document Lecture

SQL Data Manipulation Language (DML): Nested Subqueries, Aggregation, Grouping & Joins

Sign in or enroll to access the full lecture notes and interactive reader.

Module 4 • Subtopic 3
Subtopic 4Document Lecture

Advanced SQL: Views, Materialized Views, Stored Procedures, Triggers & Cursors

Sign in or enroll to access the full lecture notes and interactive reader.

Module 4 • Subtopic 4
Subtopic 1Open Access~3 min read

Mid-Semester Case Study & Research Paper

Sign in or enroll to access the full lecture notes and interactive reader.

Module 5 • Subtopic 1•104 characters of authentic academic content
Subtopic 2Document Lecture

Informal Design Guidelines, Redundancy, Update Anomalies & Functional Dependencies

Sign in or enroll to access the full lecture notes and interactive reader.

Module 5 • Subtopic 2
Subtopic 3Document Lecture

Armstrong's Axioms, Attribute Closure, Minimal Covers & Candidate Key Inference

Sign in or enroll to access the full lecture notes and interactive reader.

Module 5 • Subtopic 3
Subtopic 4Document Lecture

Normalization Theory: 1NF, 2NF, 3NF, Boyce-Codd Normal Form (BCNF), 4NF & Lossless Decompositions

Sign in or enroll to access the full lecture notes and interactive reader.

Module 5 • Subtopic 4
Subtopic 1Document Lecture

Physical Database Organization: File Records, Page Buffering, Heap Files & Slotted Pages

Sign in or enroll to access the full lecture notes and interactive reader.

Module 6 • Subtopic 1
Subtopic 2Document Lecture

Indexing Architectures: Primary, Clustered, Secondary Indexes, B+ Trees & Extendible Hashing

Sign in or enroll to access the full lecture notes and interactive reader.

Module 6 • Subtopic 2
Subtopic 3Document Lecture

Query Processing & Optimization: Relational Algebra Equivalence, Cost Models & Join Algorithms

Sign in or enroll to access the full lecture notes and interactive reader.

Module 6 • Subtopic 3
Subtopic 1Document Lecture

The Transaction Abstraction: ACID Properties, Schedules, Serializability & Conflict Equivalence

Sign in or enroll to access the full lecture notes and interactive reader.

Module 7 • Subtopic 1
Subtopic 2Document Lecture

Concurrency Control Protocols: Two-Phase Locking (2PL), Timestamp Ordering & Multi-Version Concurrency (MVCC)

Sign in or enroll to access the full lecture notes and interactive reader.

Module 7 • Subtopic 2
Subtopic 3Document Lecture

Database Crash Recovery: Write-Ahead Logging (WAL), Checkpointing, Undo/Redo & the ARIES Algorithm

Sign in or enroll to access the full lecture notes and interactive reader.

Module 7 • Subtopic 3
Formative Assessment10 Points • 15 Mins

Comprehensive End-of-Course Examination

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

Test your knowledge of NoSQL and Modern Database Systems

Module 8 • Formative Assessment
Subtopic 2Document Lecture

NoSQL Data Paradigms: Document Stores, Key-Value, Column-Family & Graph Databases

Sign in or enroll to access the full lecture notes and interactive reader.

Module 8 • Subtopic 2
Subtopic 3Document Lecture

Distributed Database Architectures: Data Fragmentation, Replication Protocols, Sharding & Distributed Commit (2PC)

Sign in or enroll to access the full lecture notes and interactive reader.

Module 8 • Subtopic 3
Subtopic 4Document Lecture

Modern Data Architecture: OLAP vs OLTP, Columnar Engines, Data Warehouses, Lakehouses & HTAP Systems

Sign in or enroll to access the full lecture notes and interactive reader.

Module 8 • Subtopic 4

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
Database Systems
Free$24.99100% Off
Certificate available separately for $7 after completion

Course Includes

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

Download Syllabus & Study Guide

Receive the full lecture syllabus, reading list, and milestone schedule for Database Systems.

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

Database Systems — B.Sc. | PAMCET