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
Explain outer join? Outer Join - If there are any values in one table which do not have corresponding value(s) in the other, in an equi-join which will not be chosen. Such ro

Data independence seems that "the application is independent of the access strategy and storage structure of data". In other words, the ability to change the schema definition in o

What are the three data anomalies that are likely to occur as a result of data redundancy?  Can data redundancy be completely eliminated in database approach?  Why or why not? A

All edges of a cube are expanding at a rate of 6 centimeters per second. How fast is the surface area changing when each edge is (a) 2 centimeters and (b) 10 centimeters?

In tuple relational calculus P1 → P2 is equivalent to ? A In tuple relational calculus P1→  P2 is equivalent to ¬P1 V P2. (The logical implication expression A  B, meaning

.#question. Discuss the problem which may arise during concurrency control and recovery in distributed database which are not encountered in controlized database environment.

Given the subsequent relations:    vehicle (reg_no, make, colour)    Person (eno, name, address)    Owner (eno, reg_no)   Write expressions

Question: (a) Use the following business rules to produce the E-R diagram. You should clearly show all the minimum and maximum cardinality constraint on each side of the relati