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

Computer Science - Database Management

Complete Computer Science - Database Management course with lessons, quizzes and practical questions

Instructor
Created by PAMCET Learning Team
1 Student Enrolledintermediate1 weekEnglish

Course Overview

Complete Computer Science - Database Management course with lessons, quizzes and practical questions Curriculum Structure & Core Modules: • 1. Foundations of Database Systems, ANSI/SPARC 3-Schema Architecture & Data Independence • 2. The Relational Model, Integrity Constraints...

What You'll Learn

  • Understand and apply the core concepts and terminology of Computer Science - Database Management
  • Build practical competence in University - Computer Science through structured coursework
  • Complete the full module sequence and assessments for Computer Science - Database Management
  • Apply University - Computer Science knowledge to coursework, assignments and exam-style questions

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
•
0s
Subtopic 1Document LectureOpen Access

File Systems vs DBMS: Redundancy, Inconsistency, Atomicity, and ANSI/SPARC 3-Schema Architecture

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

Module 1 • Subtopic 1
Subtopic 2Document Lecture

Data Independence: Logical vs Physical Independence and DBMS Component Architecture

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

Module 1 • Subtopic 2
Subtopic 3Document LectureOpen Access

Data Models Survey: Hierarchical, Network, Relational, Object-Oriented, and NoSQL Paradigms

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

Module 1 • Subtopic 3
Formative Assessment10 Points • 15 Mins

Assessment: Database Systems Foundations, ANSI/SPARC & Data Independence

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

Test your knowledge of Week 1: Core Topics

Module 1 • Formative Assessment
Subtopic 1Document Lecture

Relational Model Foundations: Domains, Attributes, Tuples, Relations, and Candidate Keys

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

Module 2 • Subtopic 1
Subtopic 2Document Lecture

Relational Integrity Constraints: Entity Integrity, Referential Integrity, and Foreign Keys

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

Module 2 • Subtopic 2
Subtopic 3Document LectureOpen Access

Formal Relational Algebra: Select, Project, Cartesian Product, Join Operations, and Division

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

Module 2 • Subtopic 3
Formative Assessment10 Points • 15 Mins

Assessment: The Relational Model, Integrity Constraints & Relational Algebra

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

Test your knowledge of Week 2: Core Topics

Module 2 • Formative Assessment
Subtopic 1Document Lecture

Entity-Relationship (ER) Modeling: Entity Sets, Weak Entities, Attributes, and Relationships

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

Module 3 • Subtopic 1
Subtopic 2Document Lecture

Enhanced ER (EER) Modeling: Specialization, Generalization, Categorization, and Aggregation

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

Module 3 • Subtopic 2
Subtopic 3Document LectureOpen Access

Conceptual-to-Relational Mapping: Transforming ER/EER Diagrams into Valid Relational Schemas

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

Module 3 • Subtopic 3
Formative Assessment10 Points • 15 Mins

Assessment: Conceptual Data Modeling & ER/EER to Relational Schema Mapping

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

Test your knowledge of Week 3: Core Topics

Module 3 • Formative Assessment
Subtopic 1Document Lecture

Informal Design Guidelines, Update Anomalies, and Armstrong's Axioms for Functional Dependencies

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

Module 4 • Subtopic 1
Subtopic 2Document Lecture

Classical Normal Forms: First Normal Form (1NF), Second Normal Form (2NF), and Third Normal Form (3NF)

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

Module 4 • Subtopic 2
Subtopic 3Document LectureOpen Access

Advanced Normalization: Boyce-Codd Normal Form (BCNF), Multi-Valued Dependencies (4NF), and Join Dependencies

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

Module 4 • Subtopic 3
Formative Assessment10 Points • 15 Mins

Assessment: Functional Dependencies & Database Normalization Theory (1NF - BCNF)

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

Test your knowledge of Week 4: Core Topics

Module 4 • Formative Assessment
Subtopic 1Document Lecture

SQL Schema Definition & Data Manipulation: DDL Constraints, Triggers, Views, and DML Syntax

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

Module 5 • Subtopic 1
Subtopic 2Document Lecture

Complex SQL Queries: Inner/Outer/Cross Joins, Correlated Subqueries, and Set Operations

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

Module 5 • Subtopic 2
Subtopic 3Document LectureOpen Access

Advanced SQL: Grouping Sets, Window Functions (OVER, PARTITION BY), CTEs, and Recursive Queries

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•126 characters of authentic academic content
Formative Assessment10 Points • 15 Mins

Assessment: Structured Query Language (SQL), Complex Joins & Window Functions

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

Test your knowledge of Week 5: Core Topics

Module 5 • Formative Assessment
Subtopic 1Document Lecture

Transaction Concepts, ACID Properties, System Schedules, and Serializability Theory

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

Module 6 • Subtopic 1
Subtopic 2Document Lecture

Concurrency Control Protocols: Two-Phase Locking (2PL), Strict 2PL, and Rigorous 2PL

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

Module 6 • Subtopic 2
Subtopic 3Document LectureOpen Access

Deadlock Handling (Prevention, Detection, Wait-Die, Wound-Wait) and Timestamp Ordering Protocols

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

Module 6 • Subtopic 3
Formative Assessment10 Points • 15 Mins

Assessment: Transaction Processing, Serializability & Concurrency Control Protocols

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

Test your knowledge of Week 6: Core Topics

Module 6 • Formative Assessment
Subtopic 1Document Lecture

Failure Classification, Storage Hierarchy, and the Write-Ahead Logging (WAL) Protocol

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

Module 7 • Subtopic 1
Subtopic 2Document Lecture

Checkpointing Techniques: Quiescent, Non-Quiescent, and Fuzzy Checkpointing Mechanics

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

Module 7 • Subtopic 2
Subtopic 3Document LectureOpen Access

The ARIES Recovery Algorithm: Analysis, Redo (Repeating History), and Undo Phases

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

Module 7 • Subtopic 3
Formative Assessment10 Points • 15 Mins

Assessment: Database Crash Recovery Architectures, WAL Protocol & ARIES

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

Test your knowledge of Week 7: Core Topics

Module 7 • Formative Assessment
Subtopic 1Document Lecture

Storage Layouts: Heap Files, Clustered Files, Columnar Storage, and Buffer Pool Management

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

Module 8 • Subtopic 1
Subtopic 2Document Lecture

Indexing Architectures: Primary vs Secondary Indexes, Dense vs Sparse, and B+ Tree Mechanics

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

Module 8 • Subtopic 2
Subtopic 3Document LectureOpen Access

Query Processing & Cost-Based Optimization: Relational Operator Algorithms, Heuristic Rewriting, and Cost Models

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

Module 8 • Subtopic 3
Formative Assessment10 Points • 15 Mins

Assessment: Physical Storage Organization, B+ Tree Indexing & Query Optimization

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

Test your knowledge of Week 8: Core Topics

Module 8 • Formative Assessment
Subtopic 5Open Access~3 min read

Final Assignment - Computer Science - Database Management

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

Module 8 • Subtopic 5•66 characters of authentic academic content

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

Course Includes

8 Chapters
24 Lectures
1 week
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 Computer Science - Database Management.

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