Systems architecture: Which component is properly considered the interface between functional applications and the organization’s database layer?
-
Amanagement information systems
-
Bdata-base management systems
-
Cdecision-support systems
-
Ddata-processing systems
-
ENone of the above
Answer
Correct Answer: data-base management systems
Explanation
Introduction / Context:Applications should not access physical data files directly. Instead, a specialized layer mediates access, enforces integrity and security, and provides query services. Identifying this interface layer is foundational to understanding system architecture.
Given Data / Assumptions:
- Functional applications need standardized, secure data access.
- The database is a coordinated set of integrated files (tables, indexes, catalogs).
- We must select the software layer designed for this mediation role.
Concept / Approach:The Database Management System (DBMS) is the canonical interface: it offers SQL, transaction management, concurrency control, recovery, and security. MIS and DSS are application categories that sit above the DBMS; “data-processing systems” is a broad term that may include non-database batch jobs.
Step-by-Step Solution:Identify access mediator: DBMS.Exclude higher-level application classes (MIS, DSS) that consume DBMS services.Exclude vague processing labels that do not define the interface.
Verification / Alternative check:Standard architectures: applications → DBMS → storage subsystem. DBMS exposes APIs/SQL, catalogs, and drivers.
Why Other Options Are Wrong:
- Management information systems / Decision-support systems: Consumers of data, not the interface layer.
- Data-processing systems: Too generic; can be file-based or non-database.
- None of the above: Incorrect because DBMS is correct.
Common Pitfalls:Bypassing the DBMS with ad hoc file access, leading to integrity and security problems.
Final Answer:data-base management systems