Database management system DBMS notes pdf

Database management system DBMS outline and the notes in pdf highlighted here. Database management system DBMS unit is examinable by Kenya national examination council KNEC and is mainly taught in various courses highlighted below;

  • Diploma in Information communication technology
  • Diploma in ICT module 2

DATABASE MANAGEMENT SYSTEM DBMS UNIT: This unit trainees learn more about DBMS which is a system software for creating and managing databases. A DBMS makes it possible for end users to create, protect, read, update and delete data in a database.


  1. DBMS introduction overview
  2. DBMS architecture
  3. DBMS data models
  4. DBMS data schemas
  5. DBMS data independence
  6. Entity relationship model
  7. Relational model
  8. Relational database design
  9. Storage and file structure
  10. Backup and recovery

DBMS introduction overview

This topic trainees will be able to learn; the basics of DBMS such as its architecture, data models, data schemas, data independence, E-R model, relation model, relational database design, and storage and file structure and much more.

DBMS architecture

This topic trainees will be able to learn; Database Architecture which is a representation of DBMS design. It helps to design, develop, implement, and maintain the database management system. A DBMS architecture allows dividing the database system into individual components that can be independently modified, changed, replaced, and altered

DBMS data models

This topic trainees will be able to learn; data models Some of the Data Models learned in this DBMS topic are:

  • Hierarchical Model.
  • Network Model.
  • Entity-Relationship Model.
  • Relational Model.
  • Object-Oriented Data Model.
  • Object-Relational Data Model.
  • Flat Data Model.
  • Semi-Structured Data Model.

DBMS data schemas

This topic trainees will be able to learn; DBMS Schemas which is of three types: Logical Schema, Physical Schema and view Schema. Logical Schema describes the database designed at logical level. Physical Schema describes the database designed at physical level.

DBMS data independence

This topic trainees will be able to learn; Data independence which is the type of data transparency that matters for a centralized DBMS. It refers to the immunity of user applications to changes made in the definition and organization of data

Entity relationship model

This topic trainees will be able to learn; Entity–relationship model ER model which describes the structure of a database with the help of a diagram, which is known as Entity Relationship Diagram (ER Diagram). An ER model is a design or blueprint of a database that can later be implemented as a database.

Relational model

This topic trainees will be able to learn; The relational model for database management which is an approach to managing data using a structure and language consistent with first-order predicate logic, first described in 1969 by English computer scientist Edgar F. Codd, where all data is represented in terms of tuples, grouped into relations

Relational database design

This topic trainees will be able to learn; Relational database design (RDD) which models information and data into a set of tables with rows and columns. Each row of a relation/table represents a record, and each column represents an attribute of data. The Structured Query Language (SQL) is used to manipulate relational databases.

Storage and file structure

This topic trainees will be able to learn; Storage and file, A file is a sequence of records stored in binary format. A disk drive is formatted into several blocks that can store records. File records are mapped onto those disk blocks.

Backup and recovery

This topic trainees will be able to learn; Backup and recovery which in general refers to the various strategies and operations involved in protecting your database against data loss and reconstructing the data should that loss occur.

DBMS NOTES: Many students sitting for KNEC exams have found themselves on a difficult situation on How to pass DBMS unit and avoid fails and referred results. Its easy the simple steps to follow include;

  • Reviewing previous KNEC past papers available for this unit
  • Focus on your weak topics during revision
  • Involve your Friends, Experts or tutors
  • Good timely preparation
  • Attempt all KNEC questions provided for this unit

Our comprehensive DBMS Notes in (PDF) format covers all the examinable topics with a definitive outline to enable easy understanding and guarantee flexibility in tackling the KNEC questions. You can access these and other notes from this PAGE

KNEC grading system for colleges and TVETs exams


  1. Frequency distribution table example with solution
  2. Examples & Formulas For Standard Deviation Variance Mean For Ungrouped Data
  3. Examples & formulas for standard deviation variance mean for grouped data
  4. Time series analysis least square method solved examples
  5. Price index Laspeyres Paasche’s and fisher’s ideal price index questions and answers
  6. Probability questions and answers statistics
  7. Pearson’s Coefficient of correlation formula example & solution
  8. PERT network diagram critical path example and solution project management
  9. Venn diagrams examples with solution 2 3 circles
  10. Regression equation formula how to calculate solved example



We are a group of graduates from Kenya school of TVET which is tasked with Training of Technical Trainers to teach in secondary schools and tertiary institutions, Implementation of various syllabi under TVET Programs in collaboration with stakeholders. Development of relevant syllabi for technical training in collaboration with stakeholders.

Leave a Reply

Your email address will not be published. Required fields are marked *

Back To Top