Departments › Software Development › Module III › Computerised Database Systems Management

Computerised Database Systems Management

Software Development · Level 5  ·  5 Chapters

Compiled by: Beatrice Adhiambo

Can I download Computerised Database Systems Management 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 Computerised Database Systems Management covers

Designing, creating, using, securing and maintaining a database are the five stages of Computerised Database Systems Management in Software Development Level 5. Design covers approaches, tools, structures, architecture, normalisation, entity relationship diagrams and a design report. Creation covers database management software, the development environment, objects, attributes and relationships, with workplace safety and health practices and e-waste management. Manipulation covers business rules, SQL inserts, data retrieval, modification and deletion. Security covers risks, controls, monitoring and auditing, documentation and training users, and maintenance covers schedules, performance monitoring, optimisation and reports.

■

Careers after Computerised Database Systems Management

In Kenya, mastering Computerised Database Systems Management opens doors to a wide range of opportunities where your skills are in high demand. From small businesses to large corporations, managing data efficiently is crucial for success and growth.

  • In the jua kali sector, artisans and small-scale entrepreneurs use database systems to track inventory, customer orders, and finances, helping them expand their businesses and improve service delivery.
  • County governments rely on database management to handle citizen records, manage projects, and streamline service provision, creating job opportunities for skilled database administrators and developers.
  • Large organizations like KenGen use complex database systems to manage energy production data, maintenance schedules, and employee records, requiring professionals who can design and maintain robust databases.
  • The bustling matatu industry benefits from database systems for managing routes, schedules, and payments, where your skills can help operators optimize operations and improve customer experience.
  • In agribusiness, companies like KTDA manage vast amounts of data on tea production, farmer records, and supply chains, requiring experts to develop and maintain efficient databases that boost productivity.
  • On construction sites, database management supports project management, procurement, and resource allocation, creating roles for professionals who can design tailored database solutions.
  • The hospitality industry uses database systems for booking management, customer relations, and inventory control, where your expertise can enhance operational efficiency and guest satisfaction.

By mastering these skills, you position yourself not only for employment in these dynamic sectors but also for entrepreneurship—offering database design and management services to businesses needing digital transformation. Your ability to create efficient, reliable databases will make you an invaluable asset, driving innovation and growth in Kenya’s economy.

Keep pushing forward—your expertise in database management is the key to unlocking a future filled with opportunities and success!

Chapters

1
Design database system
29 topics
Open chapter →
2
Create database system
24 topics
Open chapter →
3
Manipulate computerised database
13 topics
Open chapter →
4
Manage database security
34 topics
Open chapter →
5
Perform database maintenance
24 topics
Open chapter →
What Computerised Database Systems Management covers: 31 main topics in 5 chapters

1. Design database system

  1. 1.1 Identification of Database design approaches
  2. 1.2 Identification of database design tools
  3. 1.3 Database structures
  4. 1.4 Database design architecture
  5. 1.5 Database normalisation
  6. 1.6 Entity Relationship diagrams
  7. 1.7 Database design report

2. Create database system

  1. 2.1 Database management software identification
  2. 2.2 Database development environment configuration
  3. 2.3 Database objects
  4. 2.4 Data attributes
  5. 2.5 Data relationships
  6. 2.6 Workplace safety and health practices
  7. 2.7 E-waste storage and disposal
  8. 2.8 E-waste management

3. Manipulate computerised database

  1. 3.1 Database business rules
  2. 3.2 Inserting data into database
  3. 3.3 Insert statement in SQL
  4. 3.4 Data retrieval from the database
  5. 3.5 Data modification using queries
  6. 3.6 Data deletion

4. Manage database security

  1. 4.1 Database security risks identification
  2. 4.2 Identification of database security control measures
  3. 4.3 Database security control measures implementation
  4. 4.4 Carrying out Monitoring and auditing of database security
  5. 4.5 Performing database security documentation
  6. 4.6 Training database users

5. Perform database maintenance

  1. 5.1 Database maintenance schedule preparation
  2. 5.2 Database performance monitoring
  3. 5.3 Database performance optimisation
  4. 5.4 Database maintenance report generation

Practise this unit

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

Revise this unit

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

Beyond the syllabus

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

Other units in Module III