(a) Define the following (i) Database (ii) Database management system (b) Mention three functions of a database management system. (c) Mention two ways through which data can be destroyed. (d) State three precautionary measure to prevent data loss.
Explanation
2 (a) Define; (i) Database; is a collection of information that is organized so that it can be easily accessed, managed and updated. (ii) Data management system; simply refers to the collection of program that assist the user to input, organize, select, manipulate, store and extract data in a database. OR It is a computer program/software application that interacts with the user, other applications that interact with the user, other applications and database itself to capture and analyze data. (b) Functions of Database; (I) Data Definition; Database management system helps to modify the structure of the existing data, removes data structure from database as well as defining new data structure for a database. (II) Update; Database management system helps in inserting, modifying and deleting data. (III) Retrieval; It helps to obtain information for end-user queries and reports by applications. (IV) Data administration; Database management system helps in registering and monitoring users, maintaining data security, recovering information if the system fails, dealing with concurring control as well as enforcing data security monitoring performance. Database also performs the following functions; (i) Organise your file to give you more control over your data. (ii) Creates data that assist the user (iii) Enables the user to edit his/her data (iv) Update data (v) Retrieve data (c) Precautionary measures to prevent data loss; (i) By creating back-up files (ii)Updating anti-virus often (iii) Checking those who may have access to the system, through the use of password and access code. (iv) Ensuring that access to the computers are full monitored.