Get premium membership and access questions with answers, video lessons as well as revision papers.
(i) Provide backup and recovery services.
(ii) Balance conflicting user requirements.
(iii) Increase concurrency and centralized control.
(iv) Provide multiple interfaces to different classes of users.
(v) Quick and easy to find data in an electronic database by either querying, filtering or sorting, that is, providing storage structures for efficient query processing.
(vi) Control of data redundancy, that is, no repetition which is wasteful to storage and memory.
(vii) Data consistency: Data is held once hence same in all other departments.
(viii) Enhancing enforcement of security constraints and unauthorized access to data.
(ix) Data Independence: Allows changing data storage structures and operations without having to change the DBMS access programs.
(x) It can be used to provide output in a range of different formats according to the needs of the user.
(xi) A massive volume of data can be stored in a very small space because it is electronic rather than paper.
(xii) Support of multiple views of the data: Each user may see a different view of the database, which describes only the data of interest to that user.
(xiii) Sharing of data and multi-user transaction processing: Allows a set of concurrent users to retrieve and to update the database. Concurrency control within the DBMS guarantees that each transaction is correctly executed or completely aborted.
maurice.mutuku answered the question on April 11, 2018 at 06:09
- 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)
- What types of format are you likely to carry out on data in a worksheet?(Solved)
Give the types of format you are likely to carry out on data in a worksheet.
Date posted: April 10, 2018. Answers (1)
- What is the difference between "justify" with "Center across selection?"(Solved)
Distinguish between "justify" with "Center across selection"
Date posted: April 10, 2018. Answers (1)
- How would you adjust the column width entries to best fit in your spreadsheet?(Solved)
Explain how you would adjust the column width entries to best fit in your spreadsheet.
Date posted: April 10, 2018. Answers (1)