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
Why Like predicate used for? LIKE predicate: The LIKE predicate searches for strings in which have a certain pattern.

Design Of Distributed Databases: The distributed databases are mainly relational at local level. So a local database schema is the similar as that of a centralised database design

(1)     Insert into PERSON Violated constraint: - Key constraint Reason: - Primary key 1 already exists in PERSON. Dealing: - DBMS could ask the user to provide valid PER

Consider the relations City (city_name, state) Hotel (name, address) City_hotel (hotel_name, city_name, owner) Answer the following queries in relational algebra (i) Find

An Enterprising group of Entrepreneurs introduced a new business named StoreItRite which is based on data storage and retrieval services. It provides the services and the company c

Type of views :  Simple views and Difficult Views Feature Simple Views Complex Views Number of tables One

MySQL Database Merge Project Description: I have two databases, I need merge the data of one database into another Work to be done online right now. Payment can be done

Let us now make the E-R diagram for the student database as per the explanation given in the previous section. We can also states the overall logical structure of a database usi

1) Define a job scheduling strategy that will meet business requirement of reporting availability by 6am CST for the following cubes? Show the job scheduling dependencies in a pict