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

Database Management I

Master Database Management I 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 I in University - Computer Science with this structured course, covering 8 modules and practice assessments. Curriculum Structure & Core Modules: • 1. Database System Concepts, Three-Schema Architecture & Data Independence • 2. Data Modeling:...

What You'll Learn

  • Understand and apply the principles of Introduction to Database Systems
  • Work confidently through Data Models and its practical applications
  • Analyse real-world scenarios involving Entity Relationship Diagrams
  • Develop applied skills in Relational Database Concepts
  • Critically evaluate approaches to Introduction to SQL

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

Evolution from File Systems to DBMS: Data Redundancy, Inconsistency and Abstraction Layers

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

Module 1 • Subtopic 1
Subtopic 2Document Lecture

The ANSI/SPARC Three-Schema Architecture: Physical, Logical and External Independence

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

Module 1 • Subtopic 2
Subtopic 3Document Lecture

DBMS Architectural Models: Centralized, Client-Server, Multi-Tier and Cloud-Native Topologies

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

Module 1 • Subtopic 3
Subtopic 1Document Lecture

Entity-Relationship Modeling: Entities, Attributes, Relationships, Cardinality and Participation

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

Module 2 • Subtopic 1
Subtopic 2Document Lecture

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

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

Module 2 • Subtopic 2
Subtopic 3Document Lecture

Mapping Conceptual ER/EER Diagrams to Logical Relational Schemas: Structural Rules and Constraints

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

Module 2 • Subtopic 3
Subtopic 1Document Lecture

Formal Foundations of the Relational Model: Relations, Tuples, Domains and Integrity Constraints

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

Module 3 • Subtopic 1
Subtopic 2Document Lecture

Fundamental Relational Algebra Operations: Select, Project, Cartesian Product, Union and Set Difference

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

Module 3 • Subtopic 2
Subtopic 3Document Lecture

Advanced Relational Algebra: Joins (Theta, Equi, Natural, Outer), Division and Query Tree Optimization

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

Module 3 • Subtopic 3
Subtopic 1Document Lecture

Functional Dependencies: Full, Partial and Transitive Dependencies with Armstrong's Axioms

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 Relational Database Concepts

Module 4 • Formative Assessment
Subtopic 3Document Lecture

The Normalization Process: First (1NF), Second (2NF) and Third (3NF) Normal Forms

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

Module 4 • Subtopic 3
Subtopic 4Document Lecture

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

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

Module 4 • Subtopic 4
Subtopic 1Document Lecture

SQL Data Definition Language (DDL): Schemas, Tables, Data Types, Primary Keys and Foreign Key Constraints

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

Module 5 • Subtopic 1
Subtopic 2Document Lecture

SQL Data Manipulation Language (DML): Insert, Update, Delete and Complex Single-Table Filtering

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

Module 5 • Subtopic 2
Subtopic 3Document Lecture

Multi-Table SQL Joins: Inner Joins, Outer Joins, Cross Joins and Self Joins

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•109 characters of authentic academic content
Subtopic 1Document Lecture

Aggregate Functions, Grouping Mechanics and the HAVING Clause: Execution Order and Filtering

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

Module 6 • Subtopic 1
Subtopic 2Document Lecture

Nested Subqueries: Correlated vs Non-Correlated Subqueries, EXISTS, IN, ANY and ALL Operators

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

Module 6 • Subtopic 2
Subtopic 3Document Lecture

Database Views, Updatable Views and Virtual Tables: Security, Encapsulation and Materialization

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

Module 6 • Subtopic 3
Subtopic 1Document Lecture

Physical Storage Media: Disk Organization, Buffer Pool Management and Record Blocking Factors

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

Module 7 • Subtopic 1
Subtopic 2Document Lecture

File Organizations: Heap Files, Sorted Files, Hash Files and Direct Access Storage

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

Module 7 • Subtopic 2
Subtopic 3Document Lecture

Database Indexing: Primary, Clustering, Secondary Indexes and B-Tree / B+ Tree Storage Structures

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

Module 7 • Subtopic 3
Subtopic 1Document Lecture

Database Integrity Constraints: Domain Constraints, Referential Actions (CASCADE, SET NULL) and Assertion Rules

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 Basic Database Design Principles

Module 8 • Formative Assessment
Subtopic 3Document Lecture

Database Security & Access Control: Discretionary Access Control (GRANT/REVOKE), Role-Based Access Control (RBAC)

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

Module 8 • Subtopic 3
Subtopic 4Document Lecture

Database Administration, Backup Strategies, Disaster Recovery and SQL Audit Trails

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 I
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 I.

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

Database Management I — ND | PAMCET