Get premium membership and access questions with answers, video lessons as well as revision papers.

Examine any four weaknesses of a conventional file approach which database systems are meant to address

      

Examine any four weaknesses of a conventional file approach which database systems are meant to address

  

Answers


gregory
Weaknesses of a conventional file approach:
1. Data redundancy and confusion
Data redundancy is the presence of duplicate data in multiple data files. Data redundancy
occurs when different divisions, functional areas and groups in an organization
independently collect the same piece of information. Data redundancy results in high data
storage costs.
2. Program-data dependence
This refers to the tight relationship between data stored in files and the specific programs
required to update and maintain those files. Every computer program has to describe the
location and nature of data with which it works. In a conventional file environment, any
change in data requires a change in all programs that access the data.
3. Lack of flexibility
A conventional file system can deliver routine scheduled reports after extensive
programming efforts, but it cannot deliver adhoc reports or respond to unanticipated
information requirements in a timely fashion. The information required by adhoc
requests is somewhere in the system but too expensive to retrieve.
4. Poor security
Because there is little control or management of data, access to and dissemination of
information may be out of control. Management may have no way of knowing who is
accessing or even making changes to the organization‘s data.
5. Lack of data sharing and availability
The lack of control over access to data in the conventional file environment does not
make it easy for people to obtain information. Because pieces of information in different
files and different parts of the organization cannot be related to one another, it‘s virtually
impossible for information to be shared or accessed in a timely manner
gregorymasila answered the question on November 17, 2017 at 18:36


Next: Highlight the activities performed during systems delivery
Previous:  What is a goods received note? State what it contains.

View More Computer Science Questions and Answers | Return to Questions Index


Learn High School English on YouTube

Related Questions