Get premium membership and access questions with answers, video lessons as well as revision papers.
(i) Enhances data integrity by providing support which ensures that the data remains accurate in the database throughout.
(ii) It acts as a go-between the database and the application accessing it for the users, in order to facilitate communication.
(iii) It enforces security constraints through authorization of access such as the use of passwords and access privileges.
(iv) It ensures that the database is able to recover from any hardware and software failure which might cause damage.
(v) It allows several users to have access to a common data stored in the database concurrently.
(vi) It facilitates ease of access to up-to-date data for retrieval and manipulation of records.
(vii) It acts as repository of data about data (meta data), that is, a system catalogue or data dictionary which stores structures of data, relationships, integrity constraints.
(viii) To enable users to create, read-form, update and to delete data from the data database.
maurice.mutuku answered the question on April 11, 2018 at 06:39
- What are the examples of DBMS software?(Solved)
Highlight the examples of DBMS software.
Date posted: April 11, 2018. Answers (1)
- What is "Database Management System" (DBMS)?(Solved)
Define the term "Database Management System" (DBMS)
Date posted: April 11, 2018. Answers (1)
- What are the advantages of modern database systems over paper-based systems?(Solved)
Discuss the advantages modern database systems have over paper-based systems.
Date posted: April 11, 2018. Answers (1)
- In what areas may databases be used in a business enterprise?(Solved)
Highlight areas where databases may be used in a business enterprise.
Date posted: April 11, 2018. Answers (1)
- What is a Database?(Solved)
Define a Database.
Date posted: April 11, 2018. Answers (1)
- What is the procedure for printing a group of worksheets at the same time in Ms Excel?(Solved)
Describe the procedure for printing a group of worksheets at the same time in Ms Excel.
Date posted: April 11, 2018. Answers (1)
- What is "collating copy printing" and how can you control it?(Solved)
Define "collating copy printing" and show how to control it.
Date posted: April 10, 2018. Answers (1)
- What are the types of page orientation?(Solved)
Give the main types of page orientation.
Date posted: April 10, 2018. Answers (1)
- What is "Page orientation?"(Solved)
Define "Page orientation"
Date posted: April 10, 2018. Answers (1)
- What is computer printout, and why is it important for any organization?(Solved)
Define a computer printout and why it is important for any organization.
Date posted: April 10, 2018. Answers (1)
- What is the difference between a legend and a label in charting?(Solved)
Distinguish between a legend and label in charting.
Date posted: April 10, 2018. Answers (1)
- What are the steps required in creating a bar graph in Excel?(Solved)
List the steps required in creating a bar graph in Excel.
Date posted: April 10, 2018. Answers (1)
- It is often desirable and necessary to produce a chart to graphically present the data that you have created in your spreadsheet. What precaution would...(Solved)
It is often desirable and necessary to produce a chart to graphically present the data that you have created in your spreadsheet.
Highlight the precautions you would take before you produce a chart.
Date posted: April 10, 2018. Answers (1)
- How would you place a chart on your worksheet?(Solved)
List ways of placing a chart on your worksheet.
Date posted: April 10, 2018. Answers (1)
- Define the term DSS(Solved)
Define the term DSS.
Date posted: April 10, 2018. Answers (1)
- What are the types of charts in a spreadsheet?(Solved)
Discuss the types of charts in a spreadsheet.
Date posted: April 10, 2018. Answers (1)
- Mr Michael Mwamburi realized that after sorting the names of Form III class list based on the First Name column in ascending order, there were...(Solved)
Mr Michael Mwamburi realized that after sorting the names of Form III class list based on the First Name column in ascending order, there were some ties on similar names that appeared in a disorganized manner.
Advise him on how to break the tie.
Date posted: April 10, 2018. Answers (1)
- Why would you prefer to use forms for data entry in a worksheet than entering data directly onto the cells?(Solved)
Give the reason why you would prefer to use forms for data entry in a worksheet than entering data directly onto the cells.
Date posted: April 10, 2018. Answers (1)
- What is the difference between "Autofilter" and "Advanced Filter?"(Solved)
Differentiate between "Autofilter" and "Advanced Filter"
Date posted: April 10, 2018. Answers (1)
- What is the difference between Sorting and filtering?(Solved)
Differentiate between Sorting and filtering.
Date posted: April 10, 2018. Answers (1)