Designing a computerized database is a critical skill for an ICT Technician in Kenya. Effective database design enables organizations across sectors such as healthcare, education, finance, and public service to manage data efficiently, supporting decision-making and operational processes. This chapter introduces fundamentals of establishing computerized databases, focusing on understanding Database Management Systems (DBMS) and gathering accurate database requirements to ensure the system meets organizational needs.

1.1 Establishing computerized database: database requirements

Establishing a computerized database involves selecting appropriate tools, defining the structure of data storage, and ensuring the system aligns with user needs. In Kenyan organizations like county governments or SACCOs, a well-designed database supports functions ranging from financial record-keeping to client management, thus improving service delivery and data integrity. The first step is to comprehend what a DBMS entails and then systematically gather requirements from stakeholders to build a database that reflects real-world operations and constraints.

1.1.1 Introduction to DBMS

The concept of a Database Management System (DBMS) is fundamental to computerized databases. A DBMS is software that facilitates the creation, management, and use of databases, allowing users to store, retrieve, and manipulate data efficiently. In Kenya’s banking sector, for example, DBMS enables secure transaction processing and customer data management, which are essential for operational continuity and regulatory compliance.

Definition of DBMS

A DBMS is an integrated software package designed to define, create, maintain, and control access to databases. It acts as an intermediary between users and the physical database, ensuring data is consistently organized and accessible. This software handles data storage, query processing, transaction management, and security enforcement.

Core Functions of DBMS

• Data Definition: Allows the specification of data structures, types, and constraints, enabling the design of database schemas that reflect organizational data accurately.
• Data Manipulation: Provides tools such as Structured Query Language (SQL) to insert, update, delete, and retrieve data efficiently.
• Data Security: Implements access control mechanisms to ensure only authorized personnel can view or modify sensitive information, critical in sectors like healthcare.
• Transaction Management: Ensures that database transactions are processed reliably, maintaining data integrity even in the event of system failures or concurrent access.
• Backup and Recovery: Offers facilities to back up data periodically and restore it when data loss or corruption occurs, vital for business continuity in retail businesses and farms.

Types of DBMS

• Hierarchical DBMS: Organizes data in a tree-like structure, suitable for applications requiring a strict parent-child relationship.
• Network DBMS: Allows more complex many-to-many relationships, often used in telecommunications and transport sectors.
• Relational DBMS (RDBMS): Stores data in tables with rows and columns and supports SQL; widely used in Kenyan universities and banks for its flexibility and ease of use.
• Object-oriented DBMS: Manages data as objects, supporting complex data types and relationships, useful in software development firms.

Advantages of Using DBMS

• Improved Data Sharing: Enables multiple users in an organization such as a county government office to access data concurrently without conflicts.
• Data Integrity Enforcement: Maintains accuracy and consistency of data through constraints and validation rules.
• Reduced Data Redundancy: Prevents unnecessary duplication of data, lowering storage costs and improving data quality.
• Enhanced Security: Provides robust mechanisms for user authentication and authorization.
• Efficient Data Access: Optimizes query processing to deliver quick responses to user requests.

1.1.2 Database requirements gathering techniques

Gathering accurate database requirements is essential for building a system that meets the specific needs of users and stakeholders. In Kenya’s diverse organizational landscape, techniques must capture both technical and business perspectives to ensure the database supports operational workflows and reporting needs.

Interviews

Interviews involve direct discussions with stakeholders such as department heads, data entry clerks, and IT staff to understand their information needs and challenges. This technique allows in-depth exploration of user expectations and uncovers implicit requirements. For instance, interviewing staff at a county health department can reveal critical data points for patient tracking and reporting.

Questionnaires and Surveys

Structured questionnaires are distributed to a larger group of users to gather quantitative data about their database needs. This method is efficient for collecting information from dispersed teams such as employees across different branches of a retail chain. Well-designed questionnaires can identify common data fields, frequency of data access, and desired reporting formats.

Document Analysis

Reviewing existing documentation such as process manuals, forms, and reports helps analysts understand current data flows and storage methods. In a university setting, analyzing student registration forms and exam records provides insights into necessary database tables and relationships. This technique also identifies gaps and inefficiencies in current systems.

Observation

Direct observation of users performing their tasks reveals practical details that may not surface during interviews. For example, observing data entry clerks in a SACCO shows how data is captured, validated, and where errors commonly occur. This hands-on understanding informs the design of user-friendly interfaces and validation rules.

Prototyping

Developing a preliminary version of the database or user interface allows stakeholders to interact with the system early and provide feedback. Prototyping is especially useful in dynamic environments like hotel management systems, where requirements may evolve rapidly. It improves communication between developers and users, reducing misunderstandings.

Chapter Summary

This chapter explored the establishment of computerized databases by first introducing the fundamental concepts of database management systems, including key definitions, functions, applications, types, components, and architecture. It then examined techniques for gathering database requirements, emphasizing elicitation methods and the preparation of assessment reports to ensure accurate data needs capture. Various database models were discussed, highlighting relational, hierarchical, network, object-oriented, and dimensional approaches, each with distinct structures and use cases. The chapter progressed into database design, covering conceptual design through entity-relationship diagrams that define entities, attributes, and relationships with appropriate notations. Logical design was addressed by focusing on the creation of tables, identification of keys, and the process of normalization to organize data efficiently. Finally, physical design considerations were presented, including the selection of data types, implementation of indexing for performance optimization, and the enforcement of constraints to maintain data integrity. Together, these topics provide a comprehensive foundation for designing effective computerized database systems.