Which of the following is NOT typically cited as an advantage of the database approach in modern information systems?

Difficulty: Easy

Correct Answer: program-data dependency.

Explanation:

Introduction / Context:The database approach centralizes data definition and control, reducing redundancy and promoting consistency. Properly identifying advantages helps justify DBMS adoption and data governance practices.

Given Data / Assumptions:

  • DBMSs separate data definitions from application code via schemas and catalogs.
  • Centralized control supports sharing, integrity constraints, and security.
  • Tight coupling between programs and data structures is considered a drawback.

Concept / Approach:Advantages include reduced redundancy, better consistency, and improved sharing. The database approach seeks to minimize program-data dependency by using schemas, views, and metadata so applications adapt with less code change when data definitions evolve.

Step-by-Step Solution:

Evaluate each option against known database benefits.Recognize that program-data dependency is the opposite of what DBMSs aim for.Select the item that is not an advantage.

Verification / Alternative check:Data independence (logical and physical) is a core DBMS goal: changing storage or schema should minimally impact applications.

Why Other Options Are Wrong:Minimal redundancy, improved consistency, and improved sharing are classic, well-documented benefits of DBMS usage.

Common Pitfalls:Confusing program-data dependency with referential integrity; the former concerns coupling, the latter enforces relational rules.

Final Answer:program-data dependency.

Discussion & Comments

No comments yet. Be the first to comment!
Join Discussion