A college keeps a student’s address in separate files for the library and the accounts office, and only the accounts copy is updated after the student moves. Which file-processing problem does this illustrate?
Correct answer A. Data redundancy and inconsistency
Explanation
Storing the same fact in several files is redundancy, and when the copies are updated separately they disagree, which is inconsistency. A DBMS reduces this by keeping one integrated, shared copy. Data isolation is a different problem: data scattered across files in different formats, which makes writing new programs hard. An atomicity problem concerns a partially completed update after a failure.
Answer checked How we write and check questions
Discussion