Departments › Applied Statistics › Module I › Database Management System

Database Management System

Applied Statistics · Level 6  ·  7 Chapters

Can I download Database Management System notes as a PDF?

Yes. The notes download as a PDF too: every chapter has a Download PDF button above its notes. Sign in and click it. Each download comes from your plan's monthly allowance or from credits. To read before you sign in, the first topic of every chapter opens to anyone, and a Profplanet plan opens the remaining topics.

▣

What Database Management System covers

In this unit, you will be able to design and manage effective database systems that meet real-world needs by understanding user requirements and selecting the right structures and components. You will confidently organize data, establish relationships, and use SQL to extract meaningful information, ensuring your database supports smooth and efficient management operations. By the end, you’ll have the skills to build, test, and verify databases that truly empower users and drive project success.

■

Careers after Database Management System

Understanding and managing databases is a powerful skill that opens doors to many dynamic careers and business opportunities across Kenya’s growing economy. Whether you dream of working in a bustling Nairobi tech hub, supporting efficient operations in a county government, or empowering agribusinesses with better data, mastering database management sets you apart as a valuable professional who can help organizations make smart, data-driven decisions.

  • In the Kenyan Jua Kali sector, artisans and small-scale entrepreneurs rely on simple database systems to track sales, inventory, and customer information, improving their business efficiency and profitability.
  • County governments use databases to manage public records, monitor service delivery, and streamline resource allocation, creating opportunities for skilled database administrators and IT officers.
  • KenGen and other energy companies manage vast amounts of operational and customer data, requiring experts who can design and maintain robust database systems to ensure reliable power supply and billing.
  • The matatu industry increasingly adopts digital fare collection and fleet management systems, where database skills help optimize routes, track payments, and enhance customer service.
  • In agribusinesses like KTDA, databases are essential for managing farmer records, processing payments, and analyzing production data, creating roles for database designers and analysts.
  • Construction sites and firms use databases to handle project schedules, supplier information, and workforce management, where accurate data organization is critical for timely and cost-effective project delivery.
  • The hospitality sector depends on database systems to manage bookings, customer preferences, and inventory, providing opportunities for database professionals to improve guest experiences and operational efficiency.

By mastering database management, you are not just learning a technical skill—you are preparing to become a problem solver and innovator in Kenya’s diverse workplaces. Your expertise will empower organizations to harness their data for growth, and it can also help you launch your own tech solutions or consultancy, driving your career and entrepreneurial journey forward with confidence.

Chapters

1
Identify database management system
7 topics
Open chapter →
2
Design database
12 topics
Open chapter →
3
Create and manipulate database
6 topics
Open chapter →
4
Perform database testing e.g. using dummy data
11 topics
Open chapter →
5
Implement designed database (roll out)
2 topics
Open chapter →
6
Establish transaction and concurrency mechanism
3 topics
Open chapter →
7
Manage database security
4 topics
Open chapter →
What Database Management System covers: 28 main topics in 7 chapters

1. Identify database management system

  1. 1.1 Define database management management system system, components and terminologies
  2. 1.2 Classification of databases
  3. 1.3 Understand various database management system
  4. 1.4 Introduction to database management systems

2. Design database

  1. 2.1 Define data abstraction, instancesand schemas
  2. 2.2 Types of Database structures
  3. 2.3 Database operations
  4. 2.4 Data models

3. Create and manipulate database

  1. 3.1 Creation of tables
  2. 3.2 Primary manipulate database system andsecondary key
  3. 3.3 Linking of tables
  4. 3.4 Data variables
  5. 3.5 Database integration
  6. 3.6 Database Querying - SQL

4. Perform database testing e.g. using dummy data

  1. 4.1 Integration testing
  2. 4.2 DB Query testing
  3. 4.3 Database test techniques
  4. 4.4 Perform database testing
  5. 4.5 Generate test report

5. Implement designed database (roll out)

  1. 5.1 Run the designed database
  2. 5.2 Test the design and Databasefunctionality

6. Establish transaction and concurrency mechanism

  1. 6.1 Transaction mechanisms
  2. 6.2 Concurrency mechanisms
  3. 6.3 Management of multiple transactions

7. Manage database security

  1. 7.1 Restriction of access as perInternal policy
  2. 7.2 Types of restrictions
  3. 7.3 Backup and recovery methods
  4. 7.4 Statement sanitization to removeSQL injections

Revise this unit

Exam-style questions 98 Written to CDACC standard, with answers Test yourself 276 Multiple-choice, one at a time Practise questions 224 Quick recall — check you know the facts
3 more for this unit
Oral exam preparation 67 What the assessor asks, and how to answer out loud Worked calculations 35 Step-by-step maths with the common mistakes Quick cards 1,378 Myth busters, skill tips and scenarios

Beyond the syllabus

Decision simulator 7 On site, what would you do? Workplace scenarios 140 Real site situations — what would you do? Turn this into income 84 Where this skill earns — what to charge, how to find clients

Other units in Module I