Modern information and communication technology (ICT) plays a crucial role in office administration by enabling efficient data management, communication, and decision-making. Understanding database management systems (DBMS) is particularly important for office administrators who handle large volumes of information daily. In Kenya, organizations such as county government offices, banks, and universities rely heavily on DBMS to store, retrieve, and manipulate data accurately. This chapter explores the fundamental concepts of DBMS, focusing on relational databases, the role of E. F. Codd in the relational model, and alternative database models like hierarchical DBMS.

8.1 Impacts of ICT

Information and communication technology (ICT) covers computers, phones, networks, the internet and the software and services that run on them. Its use has changed how offices work: how documents are produced, how people communicate, how records are kept and even where work is done. These changes bring clear benefits, but also costs and risks that an office administrator must manage.

8.1.1 Positive

• Faster work: documents, calculations and searches that took hours by hand take minutes.
• Better communication: email, messaging and video meetings connect staff, customers and partners instantly and cheaply, wherever they are.
• Accurate records: data entered once can be checked, calculated and reused without copying errors.
• Easy storage and retrieval: large volumes of records are stored in little space and found quickly by search.
• Reduced costs: less paper, postage, travel and storage space.
• Flexible working: staff can work from home or on the move using cloud services and mobile devices.
• Better decisions: reports and charts produced from up-to-date data support managers.
• Improved customer service: online services, payments and enquiries are available at any time.
• New jobs and skills: ICT creates roles such as virtual assistants, data officers and ICT support staff, and online work opportunities.

8.1.2 Negative

• Security risks: viruses, hacking, phishing and data theft threaten the organisation's information.
• Privacy concerns: personal data held electronically can be misused or exposed.
• Job changes and losses: some routine tasks (filing clerks, typists, manual record keepers) are reduced as work is automated.
• Cost: equipment, software licences, internet, maintenance and training are costly and must be renewed.
• Dependence on technology: power cuts, network failures or system breakdowns can stop work.
• Health effects: long hours at screens cause eye strain, back and neck pain and repetitive strain injuries if workstations are poorly arranged.
• Information overload: too many emails and messages reduce concentration and productivity.
• Environmental impact: old equipment becomes electronic waste, which must be disposed of safely.
• Social isolation: remote work and online communication can reduce face-to-face contact.
• Digital divide: people without access or skills are left behind.

Managing the negative impacts

Offices reduce these effects through security measures (passwords, antivirus, backups), data protection policies, ergonomic workstations and regular breaks, staff training and retraining, backup power, email and screen-time discipline, and safe disposal of e-waste through licensed collectors.

Chapter Summary

This chapter introduced the fundamental concepts of database management systems, focusing on the relational database model and its management through relational database management systems (RDBMS). It highlighted the historical contribution of E. F. Codd, who proposed the relational model in 1970, and also touched on alternative database structures such as hierarchical DBMS. The process of installing a relational database was outlined, establishing the practical steps needed to set up the system. Key components that form the basic environment of a relational database were examined to provide an understanding of its architecture. The chapter detailed the core functions of an RDBMS including data storage, retrieval, and manipulation, emphasizing how these operations facilitate efficient data management. Practical application was demonstrated through the steps to open a new database in Microsoft Access. Finally, the various relational database objects were explained, rounding out the comprehensive exploration of modern information and communication technology in database systems.