Determine the Disadvantages of file based systems, Database Management System

Assignment Help:

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.

Related Discussions:- Determine the Disadvantages of file based systems

Keys, it can be possible to create any table without primary key

it can be possible to create any table without primary key

What is multiplicity in the associations, What is multiplicity in the assoc...

What is multiplicity in the associations? Give an example to explain multiplicity? Multiplicity in association indicate number of objects participate in any relationship. For

Clinic, Need a sample of a clinic database relationships

Need a sample of a clinic database relationships

What is a primary index, What is a primary index? A primary index is an...

What is a primary index? A primary index is an index whose search key also explains the sequential order of the file.

What is system r, What is System R? What are its two major subsystems? ...

What is System R? What are its two major subsystems? System R was intended and developed over a period of 1974-79 at IBM San Jose Research Center. It is a prototype and its pur

Prove that a relation which is 4nf must be bcnf, Prove that a relation whic...

Prove that a relation which is 4NF must be BCNF.   Ans Let R be in 4NF.  Suppose it is not in BCNF.  Hence, there exists an FD X→Y in R such that x is not a super key. Although

Write query to insert data in student table, Consider student (std_id, std_...

Consider student (std_id, std_name, date_of_birth, phone, dept_name). Put the data for a student with student id200, name arun, birth date 1 February, 1985, phone number (01110 328

What is called mirroring, What is called mirroring? The simplest approa...

What is called mirroring? The simplest approach to introducing redundancy is to duplicate each disk. This method is called mirroring or shadowing.

State the objectives of object design, Determine the OBJECTIVES of  object ...

Determine the OBJECTIVES of  object design After passing through this unit, you should be able to: describe and apply concept of generalisation; understand and appl

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd