Departments › Computer Science › Module III › Database Management

Database Management

Computer Science · Level 6  ·  6 Chapters

Can I download Database Management notes as a PDF?

Yes. 9 CDACC past papers for Database Management download as a PDF, free, with no account and no payment. 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. See the 9 free past papers for this unit.

▣

What Database Management covers

In this unit, you will be able to confidently design, create, and manage robust databases using MS SQL Server and other RDBMS tools, ensuring data is organized, secure, and efficient. You will master key concepts like relational modeling, normalization, and entity modeling, enabling you to build systems that meet real-world needs with precision. By the end, you'll navigate database interfaces with ease and apply best practices that make you a valuable asset in any data-driven environment.

■

Careers after Database Management

Database management skills open doors to a wide range of exciting career opportunities across Kenya’s vibrant economy. Whether you dream of working in bustling urban centres or supporting rural enterprises, mastering these skills empowers you to organise, secure, and analyse data that drives decision-making and growth.

  • In the Jua Kali sector, artisans and small-scale manufacturers use databases to track inventory, manage customer orders, and streamline supply chains, enhancing efficiency and profitability.
  • County governments rely on database administrators to manage public records, streamline service delivery, and support data-driven planning for community development projects.
  • Large organisations like KenGen use advanced database systems to monitor equipment, manage employee information, and analyse energy production data, creating demand for skilled database professionals.
  • The matatu industry benefits from database systems that manage fleet information, driver schedules, and fare collections, making transport services more reliable and organised.
  • In agribusiness, companies such as KTDA depend on databases to manage farmer records, track tea production, and coordinate logistics, ensuring smooth operations and fair payments.
  • Construction sites use databases to manage project timelines, resource allocations, and contractor information, helping projects stay on schedule and within budget.
  • The hospitality industry employs database management to handle bookings, customer preferences, and inventory, enhancing guest experiences and operational efficiency.

By mastering database management, you position yourself for rewarding employment in these sectors or the opportunity to start your own business offering data solutions to local enterprises. Your skills will be in high demand as Kenya embraces digital transformation, making you a vital contributor to economic growth and innovation.

Keep building your expertise—your future as a confident, skilled database professional is bright and full of possibilities!

Chapters

1
Database fundamentals
31 topics
Open chapter →
2
Database design
11 topics
Open chapter →
3
Structured Query Language
36 topics
Open chapter →
4
Design of object-oriented databases
10 topics
Open chapter →
5
Indexing and hashing
11 topics
Open chapter →
6
Database applications
8 topics
Open chapter →

9 past papers for this unit →

What Database Management covers: 43 main topics in 6 chapters

1. Database fundamentals

  1. 1.1 Definition of database fundamentals
  2. 1.2 Database terminologies
  3. 1.3 Reasons of using databases
  4. 1.4 Definition of relational model
  5. 1.5 Relational Modelling Concepts
  6. 1.6 Properties of a relation/table
  7. 1.7 Comparison of RDBMS products
  8. 1.8 Installation of MS SQL server
  9. 1.9 MS SQL server interface
  10. 1.10 Properties of MS SQL server Database
  11. 1.11 Prescribe RDBMS product for a simulated environment
  12. 1.12 Database security

2. Database design

  1. 2.1 Phases of database Design
  2. 2.2 Entity modelling
  3. 2.3 Normalisation
  4. 2.4 Validating model according to the requirements / specified transactions (CRUD matrix)

3. Structured Query Language

  1. 3.1 SQL
  2. 3.2 Data definition queries
  3. 3.3 Demonstration of CREATE TABLE statement
  4. 3.4 Demonstration of CREATE TABLE constraints:
  5. 3.5 Editing table schema using SQL ALTER statement
  6. 3.6 Dropping table using SQL DROP TABLE statement
  7. 3.7 Data manipulation query statements
  8. 3.8 Data Manipulation Query Statements
  9. 3.9 SQL Joins
  10. 3.10 Create and query a database from a validated ER model
  11. 3.11 Creating a simple join

4. Design of object-oriented databases

  1. 4.1 Object oriented database
  2. 4.2 Object oriented database concepts
  3. 4.3 Implementation of Object Oriented Database Concepts from a set of requirements
  4. 4.4 Creation of views and triggers

5. Indexing and hashing

  1. 5.1 Indexing and hashing
  2. 5.2 Demonstration of indexing
  3. 5.3 Demonstration of hashing
  4. 5.4 Implementation of indexing and hashing in an existing database

6. Database applications

  1. 6.1 Decision support system
  2. 6.2 Data mining
  3. 6.3 Distributed Databases
  4. 6.4 Features of Data warehouses
  5. 6.5 Features of Spatial and geographical databases
  6. 6.6 Features of Multi-media databases
  7. 6.7 Mobility and personal databases
  8. 6.8 Design and implementation of data warehouses

Practise this unit

The practical 92 The assessment itself: tools, materials and the marks Step-by-step guide 92 PPE, each step, what good looks like, common mistakes

Revise this unit

Past papers & answers 9 Real CDACC papers for this unit, free to download Exam-style questions 84 Written to CDACC standard, with answers Test yourself 236 Multiple-choice, one at a time Practise questions 189 Quick recall — check you know the facts
3 more for this unit
Oral exam preparation 55 What the assessor asks, and how to answer out loud Worked calculations 45 Step-by-step maths with the common mistakes Quick cards 1,188 Myth busters, skill tips and scenarios

Beyond the syllabus

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

Other units in Module III