Question 2
- Define the following (i)Database (ii)Database Management System
- Mention three functions of a database management system
- Mention two ways through which data can be destroyed
- State three precautionary measures to prevent data loss.
Observation
The expected answers were:
(a)
- Database is an organized, collection of related data.
OR
A set of data organized in a structured manner
OR
An organized, collection of similar/related data/information for easy search and retrieval
-
2. Database management system is a set of programs that enables the user to store, modify and extract information from a database.
OR
A software that manages the database.
Program that provides users with the tools to add, delete, access, modify and analyse stored data in one location.
OR
Software to create, manipulate control and retrieve data stored in database
(b) Functions of a database management system are:
- Redundancy control/Minimizes Data Repetition
- Easy access and retrieval of data
- Provision for backup and recovery
- Maintenance of data integrity
- Create database
- User access control/security/protection of data
- Data manipulation
- Data Storage Management
- Concurrence/ Multi user Access control
- Data transformation/ modification/editing
- Provision of Data Access Language and Application programming interface
- Transaction Management
- Data Dictionary Management
- Provides Database Communication interface
- Report generation/presentation/output/formatting
(c)
- Overwriting an existing file
- Hardware failure
- Virus attack/Spyware/Malware/Malicious Software
- Fire outbreak
- Power failure
- Software malfunction
- Accidental/mistaken/unintentional deletion by user/Human error
- Intentional deletion by user
- Natural disaster
- Exposure to Magnetic field
- Physical/Mechanical damages to hard drive
- Theft of Computer
(d)
- Power backup
- Data backup/safe data
- Proper shut down of computer
- Use of anti-virus software and network firewalls/anti-spyware/anti-malware
- Regular defragmentation
- Encryption
- User education
- Avoid physical/mechanical contact
- Alert/warning before deletion
- Labelling of storage devices
- Avoid water/liquid spillage
- Physical access control/restriction to computer
- Access control mechanism/PIN/Password
- Keep storage devices from magnetic substances/objects
- Avoid removing storage devices while in use
- Avoid movement of desktop computers while in operation/use