Determine the Disadvantages of file based systems, Database Management System

Determine the Disadvantages of file based systems

Some of the disadvantages of file based systems are like this:

  • Data redundancy and inconsistency: the dissimilar application programs may require similar data but may store it in separate files to be employed by them only. For instance, in a college environment, the address, contact no. etc., may be kept both by the office staff and the library staff to sent suitable reminders to the fee defaulters or to the students who have not returned the books on due dates, correspondingly. If a student alters the residence and that is reflected in only one of the system after that it leads to inconsistency.
  • Difficulty in accessing data: Although if the data is there in the file but if a new type of details is needed from the data, they cannot be retrieved if not and until a new application is written for it.
  • Data isolation: as data are scattered in several files, and files may be in different formats, writing new application programs to retrieve the suitable data is difficult.
  • Integrity problems: The integrity constraint can be applied by the application program, but not directly to the data file. For instance, there is a constraint to make sure that the balance of an account must not be below Rs. 1000, after that through application program this can be completed but someone may directly make the changes to the data file and violate this constraint.
Posted Date: 5/3/2013 7:24:19 AM | Location : United States

Related Discussions:- Determine the Disadvantages of file based systems, Assignment Help, Ask Question on Determine the Disadvantages of file based systems, Get Answer, Expert's Help, Determine the Disadvantages of file based systems Discussions

Write discussion on Determine the Disadvantages of file based systems
Your posts are moderated
Related Questions
Discuss along with examples about several types of attributes present in the ER model? Types of Attributes are: • SIMPLE attributes are attributes which are drawn from the ato

Explain the Fundamental concepts of object-orientation Software developers, data base administrators (DBAs) need to be familiar with fundamental concepts of object-orientation.

This constraint shows that the key attribute value in each tuple must be unique, i.e., no two tuples have the similar value for the key attribute. This is because the value of the

Define page. The database is partitioned into some number of fixed-length blocks, which are referred to as pages.

Illustrate the State model for the ATM class let us take state model for the ATM class given below in Figure showing state model of the ATM class and the pseudo code derived fr

There are two major types of fragmentation: Horizontal& Vertical. Horizontal fragments, as the name suggests are subsets of tuples and vertical fragments are subsets of attributes

In E-R Diagram how relationship type is represented ? In E-R Diagram relationship type is represented as a Diamond.

Question 1 What do you mean by database management system? Question 2 Write a note on Object-Oriented Model Question 3 Explain Sequential File Organization Question

An important first step to the statistical analysis of data is to "get to know your data".  The following tasks should contribute to this. (a)   To the right of the dataset cons

Design a database for an airline.The database must keep track of customers and their reservations,flights and their status, seat assignment on individual flights and, the schedule