Computerised Database Systems Management

Software Development · Level 6  ·  5 Chapters

Compiled by: John Okoth

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

Every system that stores records needs a well-designed, well-kept database, so Software Development Level 6 teaches Computerised Database Systems Management. The first outcome designs a database through approaches, tools, normalisation and entity relationship diagrams. The second creates it, with software selection, environment set-up, objects, attributes, relationships, safe working practices and e-waste handling. The third inserts, retrieves, modifies and deletes data following business rules, using SQL. Database security and its documentation come fourth, with auditing and user training, and the last outcome schedules maintenance and reports on performance.

■

Careers after Computerised Database Systems Management

Understanding and managing computerised database systems is a powerful skill that opens doors to numerous career opportunities across Kenya’s vibrant economy. From bustling Nairobi tech hubs to agribusiness firms in Kericho, your ability to design and manage databases ensures that information is organised, accessible, and secure—making you indispensable in today’s data-driven workplaces.

  • In the Kenya Tea Development Agency (KTDA) and other agribusiness companies, database systems track crop yields, manage supply chains, and monitor payments to farmers, ensuring efficient operations and timely decision-making.
  • The Jua Kali sector increasingly uses digital records for inventory and customer management, where your skills can help artisans and small businesses streamline their data handling and grow their enterprises.
  • At KenGen and other energy firms, well-designed databases manage asset information, maintenance schedules, and project documentation, supporting Kenya’s push for sustainable energy solutions.
  • The matatu industry benefits from database systems that handle route management, driver records, and fare collections, improving service reliability and safety.
  • In county government offices and construction sites, database systems are essential for managing project data, procurement records, and human resource information, helping counties deliver services efficiently.
  • The booming hospitality sector in Kenya relies on databases for booking systems, customer loyalty programs, and inventory control, where your expertise can enhance guest experiences and operational efficiency.
  • Whether employed by a company or running your own IT consultancy, mastering database design and management empowers you to create solutions that save time and resources, making you highly sought after in both formal and informal sectors.

By mastering computerised database systems management, you position yourself at the heart of Kenya’s digital transformation, equipped to build a rewarding career that supports businesses, communities, and the nation’s growth. Your skills will not only open doors to employment but also enable you to innovate and lead in the fast-evolving tech landscape. Keep learning, stay curious, and watch your future unfold!

Chapters

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

Revise this unit

3 more for this unit

Beyond the syllabus

Other units in Module III