Difficulty: Easy
Correct Answer: processing functions
Explanation:
Introduction / Context:
In a classical database environment, the division of labor between application programs and the database management system (DBMS) matters. The DBMS provides storage, access paths, and security primitives, while application programs implement business logic. This question asks which tasks application programs typically undertake in the “DBM approach.”
Given Data / Assumptions:
Concept / Approach:
Application programs are primarily responsible for processing functions—that is, implementing business logic, calculations, workflows, and user interactions. The DBMS generally handles storage functions (physical organization, indexing, logging) and access control (privileges, roles, authentication). While applications may invoke or supplement access control, the canonical responsibility for storage and core access mechanisms lies with the DBMS layer.
Step-by-Step Solution:
Identify what each layer traditionally owns.Map responsibilities: DBMS = storage + access methods/security primitives; Application = business processing.Select the option that best fits the application’s domain: “processing functions.”
Verification / Alternative check:
Review common architectures: 3-tier systems isolate the data tier (DBMS) from the application tier (logic). Even in client–server, SQL encapsulates data operations; applications orchestrate processes and rules.
Why Other Options Are Wrong:
Common Pitfalls:
Assuming that because applications can enforce some security, they “own” access control; mixing responsibilities can cause duplicated logic and inconsistencies.
Final Answer:
processing functions
Discussion & Comments