3.1 Computerised Database User Requirements Collection

Accurate collection of user requirements is fundamental to developing a computerized database that aligns with organizational goals and user expectations. In Kenya, ICT Operators often engage with diverse stakeholders from county governments, banks, hospitals, and educational institutions to gather these requirements. This process ensures that the database supports essential business processes, complies with regulatory standards like the Data Protection Act, and enhances operational efficiency.

3.1.1 Introduction to Database

A database is an organized collection of data stored electronically to facilitate easy access, management, and updating. It serves as the core repository for information used in decision-making and daily operations across Kenyan institutions. For instance, a SACCO uses a database to track member savings, loan applications, and repayments, enabling timely financial services.

Characteristics of Databases

• Structured Data Storage: Databases store data in structured formats like tables, which allow efficient querying and reporting.
• Data Integrity: Databases enforce rules to maintain accuracy and consistency of data, essential for trustworthy records in hospitals or banks.
• Multi-user Access: They allow multiple users to access and manipulate data simultaneously without conflict, supporting collaborative environments like universities or government offices.
• Data Security: Databases implement access controls and encryption to protect sensitive information from unauthorized use, critical in sectors handling personal data.
• Scalability: Databases can handle increasing data volumes as organizations grow, such as expanding customer records in retail chains.

Types of Databases Commonly Used

• Relational Databases: Use tables related by keys; popular in Kenyan financial institutions for transactional data.
• NoSQL Databases: Handle unstructured data; useful in social media analytics for marketing firms.
• Cloud Databases: Hosted on cloud platforms, offering flexibility and remote access for county government systems.
• Distributed Databases: Data spread across multiple locations; applicable in multi-branch retail businesses.
• In-memory Databases: Store data in RAM for rapid access; used in real-time applications like stock trading platforms.

Role of Databases in Kenyan Organizations

Databases support operational efficiency by automating data management tasks. For example, in Nairobi County health facilities, patient records are maintained in computerized databases to improve service delivery and reduce paperwork. Similarly, universities use databases to manage student admissions, course registrations, and examination results efficiently.

3.1.2 Collection of User Requirements

Gathering user requirements is a critical step that involves understanding the data needs, workflows, and expectations of end users. ICT Operators in Kenya must employ systematic methods to ensure that the database design reflects the actual operational environment and supports decision-making.

Techniques for Gathering User Requirements

• Interviews: Conduct face-to-face or virtual discussions with stakeholders such as hospital administrators or bank managers to understand their data needs and challenges.
• Questionnaires and Surveys: Distribute structured forms to users across departments in county offices to collect quantitative data on desired features.
• Observation: Study existing processes in retail businesses or schools to identify how data is currently managed and where improvements are necessary.
• Document Analysis: Review existing records, reports, and forms used by organizations like NEMA to identify key data elements and reporting requirements.
• Workshops: Facilitate collaborative sessions with users from various departments in hotels or cooperatives to gather comprehensive requirements and build consensus.

Key User Requirements to Identify

• Data Types and Formats: Determine the kinds of data to be stored, such as numeric financial data, textual patient records, or multimedia files.
• Data Volume and Growth: Assess the expected size of the database and future expansion to ensure scalability.
• Access Levels and Security Needs: Identify who needs access and what permissions they require, for example, limiting sensitive data access in insurance firms.
• Reporting and Query Needs: Understand the types of reports and queries users will run to support decision-making.
• Integration with Other Systems: Determine if the database must interface with existing software, like accounting systems in SACCOs.

Challenges in Requirements Collection and Overcoming Them

• Incomplete User Input: Users may not fully express their needs; using multiple techniques like interviews and observation helps uncover hidden requirements.
• Conflicting Requirements: Different departments may have opposing needs; workshops facilitate negotiation and prioritization.
• Technical Jargon Barrier: Users might lack technical knowledge; ICT Operators should translate technical terms into understandable language.
• Changing Requirements: Business processes evolve; establishing a feedback loop ensures continuous alignment.
• Time Constraints: Limited time for engagement requires efficient scheduling and focused sessions.

Chapter Summary

This chapter explored the essential processes involved in maintaining a computerized database, beginning with the collection of user requirements which forms the foundation for effective database design. It introduced key concepts of databases including their organization, relationships, and operations that support data management. The design phase covered the creation of database schemas through models such as Entity-Relationship Diagrams and relational models, which help structure the data logically. The chapter then detailed the creation of various database objects including tables, records, fields, keys, forms, queries, and reports, each serving distinct roles in data handling. Data manipulation techniques were examined, focusing on inserting, retrieving, deleting, and updating records to ensure accurate and current information. Finally, the chapter addressed the printing of database objects like tables, forms, queries, and reports, enabling effective presentation and dissemination of data. Together, these topics provide a comprehensive understanding of how to maintain and operate computerized databases efficiently.