Skip to main content
ND DegreeFaculty of Faculty of Computing & Information TechnologyComputer Science

Database Management II

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

Instructor
Created by PAMCET Learning Team
beginner1 weekEnglish

Course Overview

Master Database Management II in University - Computer Science with this structured course, covering 8 modules and practice assessments. Curriculum Structure & Core Modules: • 1. Advanced Relational Database Design, Boyce-Codd Normal Form (BCNF) & Fourth Normal Form (4NF) • 2....

What You'll Learn

  • Understand and apply the principles of Normalisation Techniques
  • Work confidently through Advanced SQL Queries and its practical applications
  • Analyse real-world scenarios involving Views and Indexes
  • Develop applied skills in Transactions and Concurrency Control
  • Critically evaluate approaches to Database Security

Requirements

  • No prior University - Computer Science knowledge required — this course starts from the fundamentals
  • 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 ND 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
•
0s
Subtopic 1Document Lecture

Functional Dependencies, Minimal Covers, and Boyce-Codd Normal Form (BCNF) Decomposition

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

Module 1 • Subtopic 1
Subtopic 2Document Lecture

Multi-Valued Dependencies, Fourth Normal Form (4NF), and Lossless-Join Decomposition Verification

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

Module 1 • Subtopic 2
Subtopic 3Document Lecture

Fifth Normal Form (5NF), Domain-Key Normal Form (DKNF), and Denormalization Trade-Offs

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

Module 1 • Subtopic 3
Subtopic 1Document Lecture

Transactional Foundations: Atomicity, Consistency, Isolation, Durability, and Schedules

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

Module 2 • Subtopic 1
Subtopic 2Document Lecture

Serializability Theory, Conflict vs. View Serializability, and Testing for Serializability

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

Module 2 • Subtopic 2
Subtopic 3Document Lecture

Concurrency Control Protocols: Two-Phase Locking (2PL), Timestamp Ordering, and Validation Techniques

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

Module 2 • Subtopic 3
Subtopic 1Document Lecture

Deadlock Management, Wait-For Graphs, Prevention Schemes (Wait-Die, Wound-Wait), and Recovery

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

Module 3 • Subtopic 1
Subtopic 2Document Lecture

ANSI SQL Isolation Levels: Read Uncommitted, Read Committed, Repeatable Read, and Serializable Anomalies

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

Module 3 • Subtopic 2
Subtopic 3Document Lecture

Multi-Version Concurrency Control (MVCC): Snapshot Isolation, Write Skew, and Vacuuming Mechanics

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

Module 3 • Subtopic 3
Subtopic 1Document Lecture

Failure Classification: Transaction Failures, System Crashes, Disk Failures, and Storage Hierarchies

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

Module 4 • Subtopic 1
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 Transactions and Concurrency Control

Module 4 • Formative Assessment
Subtopic 3Document Lecture

Write-Ahead Logging (WAL), Steal/No-Steal and Force/No-Force Buffer Management Policies

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

Module 4 • Subtopic 3
Subtopic 4Document Lecture

The ARIES Recovery Algorithm: Analysis, Redo (Repeating History), and Undo (Compensation Log Records)

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

Module 4 • Subtopic 4
Subtopic 1Document Lecture

Physical Storage Organization: Heap Files, Page Layouts, Slotted Pages, and Record Identifiers (RIDs)

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

Module 5 • Subtopic 1
Subtopic 2Document Lecture

Tree-Structured Indexing: B+ Trees, Search, Insert, Delete, Node Splitting, and Dynamic Rebalancing

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

Module 5 • Subtopic 2
Subtopic 3Document Lecture

Hash-Based Indexing: Static Hashing, Extendible Hashing, Linear Hashing, and Bitmap Indexes

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

Module 5 • Subtopic 3
Subtopic 4Open 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 4•110 characters of authentic academic content
Subtopic 1Document Lecture

Query Processing Steps: Parsing, Translation, Relational Algebra Equivalence Rules, and Query Trees

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

Module 6 • Subtopic 1
Subtopic 2Document Lecture

Physical Operator Algorithms: Nested-Loop Joins, Block Nested-Loop, Sort-Merge Join, and Hash Join

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

Module 6 • Subtopic 2
Subtopic 3Document Lecture

Cost Estimation, Database Catalogs, Histogram Statistics, and Dynamic Programming Optimization

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

Module 6 • Subtopic 3
Subtopic 1Document Lecture

Distributed DBMS Architecture: Horizontal/Vertical Fragmentation, Allocation, and Distributed Catalogs

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

Module 7 • Subtopic 1
Subtopic 2Document Lecture

Distributed Concurrency & Consensus: Two-Phase Commit (2PC), Three-Phase Commit (3PC), and Paxos/Raft

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

Module 7 • Subtopic 2
Subtopic 3Document Lecture

Distributed Data Replication: Master-Replica, Multi-Master, Eventual Consistency, and The CAP Theorem

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

Module 7 • Subtopic 3
Subtopic 1Document Lecture

NoSQL Paradigms: Key-Value Stores, Document Stores (MongoDB), Column-Family Stores (Cassandra), and Graph Databases (Neo4j)

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

Module 8 • Subtopic 1
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 Database Administration Basics

Module 8 • Formative Assessment
Subtopic 3Document Lecture

NewSQL Systems: Google Spanner, CockroachDB, TrueTime API, and Distributed Serializable ACID

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

Module 8 • Subtopic 3
Subtopic 4Document Lecture

Analytical Data Platforms: Data Warehousing, Star/Snowflake Schemas, OLAP vs. OLTP, and Lakehouse Architectures

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 Management II
Free$17.99100% Off
Certificate available separately for $7 after completion

Course Includes

8 Chapters
24 Lectures
1 week
Skill Level beginner
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 Management II.

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