Skip to main content
B.Sc. DegreeFaculty of Faculty of Computing & Information TechnologyCyber Security

CYS 110: Database Systems Fundamentals

Comprehensive grounding in database management systems (DBMS) architecture, relational database theory, structured query language (SQL), and database security foundations. Covers relational algebra (selection, projection, joins, Cartesian product), E...

Instructor
Created by PAMCET Learning Team
beginner1 - 2 weeksEnglish

Course Overview

Comprehensive grounding in database management systems (DBMS) architecture, relational database theory, structured query language (SQL), and database security foundations. Covers relational algebra (selection, projection, joins, Cartesian product), E... Curriculum Structure &...

What You'll Learn

  • Design normalized relational database schemas from requirements using Entity-Relationship modeling.
  • Formulate efficient SQL queries involving multi-table joins, subqueries, aggregations, and views.
  • Explain ACID properties and evaluate concurrency control techniques (locking, isolation levels).
  • Configure fine-grained database privileges, roles, and access control matrices on production DBMS engines.
  • Demonstrate how unparameterized dynamic SQL causes injection vulnerabilities and remediate using prepared statements.

Requirements

  • Foundational academic standing in computing, mathematics, or science.

Degree Programme Curriculum Context

This course is a curriculum unit of the B.Sc. Cyber Security 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
•
16 Lecture
•
12h
Subtopic 1Document LectureOpen Access~28 min read

Lecture 1: File Systems vs DBMS: Data Redundancy, Inconsistency, and Query Flexibility

CYS 110 • Chapter 1 • Lecture 1 CCMAS: CCMAS-CYS-110 File Systems vs DBMS: Data Redundancy, Inconsistency, and Query Flexibility Module: Database System Concepts, Architecture & Data Independence • Theoretical Foundations & Formal Models Level: 100L Credits: 3 CU Discipline: Computing Foundations Thread: Computing & Systems Foundations Study Time: 45 Mins 1. Pedagogical Abstract...

Module 1 • Subtopic 1•23,753 characters of authentic academic content
Subtopic 2Document Lecture

Lecture 2: Three-Schema Architecture: External, Conceptual, and Internal Levels with Data Independence

CYS 110 • Chapter 1 • Lecture 2 CCMAS: CCMAS-CYS-110 Three-Schema Architecture: External, Conceptual, and Internal Levels with Data Independence Module: Database System Concepts, Architecture & Data Independence • Worked Technical Scenarios & Lab Protocols Level: 100L Credits: 3 CU Discipline: Computing Foundations Thread: Computing & Systems Foundations Study Time: 45 Mins 1. P...

Module 1 • Subtopic 2
Formative Assessment10 Points • 15 Mins

Formative Assessment: Database System Concepts, Architecture & Data Independence

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

Formative knowledge check evaluating core concepts, security invariants, and analytical skills for Database System Concepts, Architecture & Data Independence.

Module 1 • Formative Assessment
Subtopic 1Document Lecture

Lecture 1: ER Modeling: Entities, Attributes, Relationships, Cardinality Ratios, and Key Constraints

CYS 110 • Chapter 2 • Lecture 1 CCMAS: CCMAS-CYS-110 ER Modeling: Entities, Attributes, Relationships, Cardinality Ratios, and Key Constraints Module: Entity-Relationship (ER) Modeling & Conceptual Schema Design • Theoretical Foundations & Formal Models Level: 100L Credits: 3 CU Discipline: Computing Foundations Thread: Computing & Systems Foundations Study Time: 45 Mins 1. Peda...

Module 2 • Subtopic 1
Subtopic 2Document Lecture

Lecture 2: Mapping ER Diagrams to Relational Schemas: Primary Keys, Foreign Keys, and Referential Integrity

CYS 110 • Chapter 2 • Lecture 2 CCMAS: CCMAS-CYS-110 Mapping ER Diagrams to Relational Schemas: Primary Keys, Foreign Keys, and Referential Integrity Module: Entity-Relationship (ER) Modeling & Conceptual Schema Design • Worked Technical Scenarios & Lab Protocols Level: 100L Credits: 3 CU Discipline: Computing Foundations Thread: Computing & Systems Foundations Study Time: 45 Mi...

Module 2 • Subtopic 2
Formative Assessment10 Points • 15 Mins

Formative Assessment: Entity-Relationship (ER) Modeling & Conceptual Schema Design

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

Formative knowledge check evaluating core concepts, security invariants, and analytical skills for Entity-Relationship (ER) Modeling & Conceptual Schema Design.

Module 2 • Formative Assessment
Subtopic 1Document Lecture

Lecture 1: Relational Algebra Operators: Select, Project, Union, Difference, Cartesian Product, and Natural Join

CYS 110 • Chapter 3 • Lecture 1 CCMAS: CCMAS-CYS-110 Relational Algebra Operators: Select, Project, Union, Difference, Cartesian Product, and Natural Join Module: Relational Data Model, Relational Algebra & Constraints • Theoretical Foundations & Formal Models Level: 100L Credits: 3 CU Discipline: Computing Foundations Thread: Computing & Systems Foundations Study Time: 45 Mins...

Module 3 • Subtopic 1
Subtopic 2Document Lecture

Lecture 2: Functional Dependencies, Closure Sets, and Normalization Theory Motivation

CYS 110 • Chapter 3 • Lecture 2 CCMAS: CCMAS-CYS-110 Functional Dependencies, Closure Sets, and Normalization Theory Motivation Module: Relational Data Model, Relational Algebra & Constraints • Worked Technical Scenarios & Lab Protocols Level: 100L Credits: 3 CU Discipline: Computing Foundations Thread: Computing & Systems Foundations Study Time: 45 Mins 1. Pedagogical Abstract...

Module 3 • Subtopic 2
Formative Assessment10 Points • 15 Mins

Formative Assessment: Relational Data Model, Relational Algebra & Constraints

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

Formative knowledge check evaluating core concepts, security invariants, and analytical skills for Relational Data Model, Relational Algebra & Constraints.

Module 3 • Formative Assessment
Subtopic 1Document Lecture

Lecture 1: Normal Forms: First (1NF), Second (2NF), Third (3NF), and Boyce-Codd (BCNF) Decomposition

CYS 110 • Chapter 4 • Lecture 1 CCMAS: CCMAS-CYS-110 Normal Forms: First (1NF), Second (2NF), Third (3NF), and Boyce-Codd (BCNF) Decomposition Module: Database Normalization: Functional Dependencies, 1NF to BCNF • Theoretical Foundations & Formal Models Level: 100L Credits: 3 CU Discipline: Computing Foundations Thread: Computing & Systems Foundations Study Time: 45 Mins 1. Peda...

Module 4 • Subtopic 1
Subtopic 2Document Lecture

Lecture 2: SQL DDL: CREATE, ALTER, DROP, Constraints (UNIQUE, NOT NULL, CHECK, FOREIGN KEY)

CYS 110 • Chapter 4 • Lecture 2 CCMAS: CCMAS-CYS-110 SQL DDL: CREATE, ALTER, DROP, Constraints (UNIQUE, NOT NULL, CHECK, FOREIGN KEY) Module: Database Normalization: Functional Dependencies, 1NF to BCNF • Worked Technical Scenarios & Lab Protocols Level: 100L Credits: 3 CU Discipline: Computing Foundations Thread: Computing & Systems Foundations Study Time: 45 Mins 1. Pedagogica...

Module 4 • Subtopic 2
Formative Assessment10 Points • 15 Mins

Formative Assessment: Database Normalization: Functional Dependencies, 1NF to BCNF

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

Formative knowledge check evaluating core concepts, security invariants, and analytical skills for Database Normalization: Functional Dependencies, 1NF to BCNF.

Module 4 • Formative Assessment
Subtopic 1Document Lecture

Lecture 1: SQL DML: SELECT, INSERT, UPDATE, DELETE, GROUP BY, HAVING, and Aggregation Functions

CYS 110 • Chapter 5 • Lecture 1 CCMAS: CCMAS-CYS-110 SQL DML: SELECT, INSERT, UPDATE, DELETE, GROUP BY, HAVING, and Aggregation Functions Module: Structured Query Language (SQL): DDL, DML & Advanced Queries • Theoretical Foundations & Formal Models Level: 100L Credits: 3 CU Discipline: Computing Foundations Thread: Computing & Systems Foundations Study Time: 45 Mins 1. Pedagogic...

Module 5 • Subtopic 1
Subtopic 2Document Lecture

Lecture 2: Advanced SQL: Inner/Outer Joins, Correlated Subqueries, Common Table Expressions (CTEs), and Views

CYS 110 • Chapter 5 • Lecture 2 CCMAS: CCMAS-CYS-110 Advanced SQL: Inner/Outer Joins, Correlated Subqueries, Common Table Expressions (CTEs), and Views Module: Structured Query Language (SQL): DDL, DML & Advanced Queries • Worked Technical Scenarios & Lab Protocols Level: 100L Credits: 3 CU Discipline: Computing Foundations Thread: Computing & Systems Foundations Study Time: 45...

Module 5 • Subtopic 2
Formative Assessment10 Points • 15 Mins

Formative Assessment: Structured Query Language (SQL): DDL, DML & Advanced Queries

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

Formative knowledge check evaluating core concepts, security invariants, and analytical skills for Structured Query Language (SQL): DDL, DML & Advanced Queries.

Module 5 • Formative Assessment
Subtopic 1Document Lecture

Lecture 1: Database Indexing: B-Tree and Hash Index Structures, Query Optimization, and Execution Plans

CYS 110 • Chapter 6 • Lecture 1 CCMAS: CCMAS-CYS-110 Database Indexing: B-Tree and Hash Index Structures, Query Optimization, and Execution Plans Module: Transactions, Concurrency Control & ACID Properties • Theoretical Foundations & Formal Models Level: 100L Credits: 3 CU Discipline: Computing Foundations Thread: Computing & Systems Foundations Study Time: 45 Mins 1. Pedagogica...

Module 6 • Subtopic 1
Subtopic 2Document Lecture

Lecture 2: Transaction Management: ACID Guarantees, Commit/Rollback, and Write-Ahead Logging (WAL)

CYS 110 • Chapter 6 • Lecture 2 CCMAS: CCMAS-CYS-110 Transaction Management: ACID Guarantees, Commit/Rollback, and Write-Ahead Logging (WAL) Module: Transactions, Concurrency Control & ACID Properties • Worked Technical Scenarios & Lab Protocols Level: 100L Credits: 3 CU Discipline: Computing Foundations Thread: Computing & Systems Foundations Study Time: 45 Mins 1. Pedagogical...

Module 6 • Subtopic 2
Formative Assessment10 Points • 15 Mins

Formative Assessment: Transactions, Concurrency Control & ACID Properties

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

Formative knowledge check evaluating core concepts, security invariants, and analytical skills for Transactions, Concurrency Control & ACID Properties.

Module 6 • Formative Assessment
Subtopic 1Document Lecture

Lecture 1: Concurrency Control: Dirty Reads, Non-Repeatable Reads, Phantom Reads, and Isolation Levels (Serializable)

CYS 110 • Chapter 7 • Lecture 1 CCMAS: CCMAS-CYS-110 Concurrency Control: Dirty Reads, Non-Repeatable Reads, Phantom Reads, and Isolation Levels (Serializable) Module: Database Security Architecture, Privileges & Encryption • Theoretical Foundations & Formal Models Level: 100L Credits: 3 CU Discipline: Computing Foundations Thread: Computing & Systems Foundations Study Time: 45...

Module 7 • Subtopic 1
Subtopic 2Document Lecture

Lecture 2: Database Authentication, Discretionary Access Control (GRANT/REVOKE), and Principle of Least Privilege

CYS 110 • Chapter 7 • Lecture 2 CCMAS: CCMAS-CYS-110 Database Authentication, Discretionary Access Control (GRANT/REVOKE), and Principle of Least Privilege Module: Database Security Architecture, Privileges & Encryption • Worked Technical Scenarios & Lab Protocols Level: 100L Credits: 3 CU Discipline: Computing Foundations Thread: Computing & Systems Foundations Study Time: 45 M...

Module 7 • Subtopic 2
Formative Assessment10 Points • 15 Mins

Formative Assessment: Database Security Architecture, Privileges & Encryption

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

Formative knowledge check evaluating core concepts, security invariants, and analytical skills for Database Security Architecture, Privileges & Encryption.

Module 7 • Formative Assessment
Subtopic 1Document Lecture

Lecture 1: Database Encryption: Transparent Data Encryption (TDE), Column-Level Encryption, and TLS Transport

CYS 110 • Chapter 8 • Lecture 1 CCMAS: CCMAS-CYS-110 Database Encryption: Transparent Data Encryption (TDE), Column-Level Encryption, and TLS Transport Module: Database Vulnerabilities: SQL Injection Mechanics & Defensive Coding • Theoretical Foundations & Formal Models Level: 100L Credits: 3 CU Discipline: Computing Foundations Thread: Computing & Systems Foundations Study Time...

Module 8 • Subtopic 1
Subtopic 2Document Lecture

Lecture 2: SQL Injection (SQLi) Fundamentals: Classic 'OR 1=1', Error-Based, and Prepared Statement Remediation

CYS 110 • Chapter 8 • Lecture 2 CCMAS: CCMAS-CYS-110 SQL Injection (SQLi) Fundamentals: Classic 'OR 1=1', Error-Based, and Prepared Statement Remediation Module: Database Vulnerabilities: SQL Injection Mechanics & Defensive Coding • Worked Technical Scenarios & Lab Protocols Level: 100L Credits: 3 CU Discipline: Computing Foundations Thread: Computing & Systems Foundations Study...

Module 8 • Subtopic 2
Formative Assessment10 Points • 15 Mins

Formative Assessment: Database Vulnerabilities: SQL Injection Mechanics & Defensive Coding

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

Formative knowledge check evaluating core concepts, security invariants, and analytical skills for Database Vulnerabilities: SQL Injection Mechanics & Defensive Coding.

Module 8 • Formative Assessment

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

Course Includes

8 Chapters
16 Lectures
1 - 2 weeks
Skill Level beginner
Taught in English
Lifetime Access
Certification of Completion
Category: University - Cyber Security
Share On

Download Syllabus & Study Guide

Receive the full lecture syllabus, reading list, and milestone schedule for CYS 110: Database Systems Fundamentals.

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

CYS 110: Database Systems Fundamentals | PAMCET University — B.Sc. | PAMCET