Primary objectives of DBMSs: Database management systems are intended to achieve which of the following goals in multi-user information environments?

Introduction / Context:
DBMSs were created to solve data sprawl and inconsistency by centralizing control of structure, access, and integrity. Understanding the full scope of their objectives helps organizations design robust data platforms that scale with business needs.

Given Data / Assumptions:

• Multiple applications and users share common data.
• Redundancy increases storage costs and inconsistency risk.
• Relationships, access control, and integrity constraints are necessary for reliable operations.

Concept / Approach:
A DBMS provides a schema to model relationships between entities (tables linked by keys), eliminates uncontrolled duplication through normalization and shared access, centrally manages who can read/write which data, and enforces integrity with constraints and transactions. These capabilities collectively produce consistency, security, and performance at scale.

Step-by-Step Solution:
Map redundancy reduction to normalization and single sources of truth.Map relationships to foreign keys and referential integrity.Map file/data access management to privileges, roles, and concurrency control.Map integrity to constraints, validations, and ACID transactions.Select the inclusive option capturing all goals.

Verification / Alternative check:
DBMS feature lists consistently highlight schema management, constraints, indexing, security, and transaction support as core reasons to adopt a DBMS rather than ad-hoc files.

Why Other Options Are Wrong:
Any single item is only part of the mission; a DBMS simultaneously addresses redundancy, relationships, access, and integrity.

Common Pitfalls:
Using a DBMS but bypassing constraints or governance replicates the same problems it was meant to solve—ensure features are enabled and policies enforced.

Final Answer:
All of the above