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.

DATABASE MANAGEMENT SYSTEM DBMS TOPICS COVERED

  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.

For short simplified and comprehensive notes examined by KNEC contact your business department or DBMS lecturer.

FREE KNEC PAST PAPERS PDF FORMAT:

COURSE NOTES

our website is customized to provide authentic credible reliable and timely information to help our readers with useful information to apply to day-to-day life. We provide our readers with authentic and original information which is practical and also clearly researched and proved. subscribe to our free newsletter using your email to receive timely updates

Leave a Reply

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

Back To Top