Question 1
15 marks
Healthcare Regulatory Agency centralized product database and user interaction
- Databases
(a)
3 marks
- Define a database as a structured repository storing logically related data regarding a specific activity or domain.
- Contrast this with an information system, which encompasses the underlying database as one core component.
- Explain that an information system integrates the database with broader hardware, software, user interfaces, procedures, and personnel to collect, process, and distribute information.
Mentor tip
Always distinguish the storage layer (database) from the complete socio-technical ecosystem (information system).
(b)
2 marks
- Guarantees data consistency across all participating pharmacies at any given moment.
- Enables single-point central updates by the regulatory agency, immediately propagating changes without synchronizing local copies.
Mentor tip
Focus on single-source-of-truth advantages: real-time consistency and centralized maintenance.
(c)
1 mark
Identify the read-only query or retrieval function used to search and inspect authorized product specifications.
Mentor tip
Pharmacists only verify existing records; do not list write, update, or modification operations.
(d)
3 marks
- Multiple pharmacists across different locations access the Healthcare Regulatory Agency database simultaneously.
- The DBMS manages these overlapping requests concurrently so users experience seamless, parallel read access.
- Equal, non-blocking access is preserved so one pharmacist's product query does not delay or corrupt another's session.
Mentor tip
Break concurrency down into: multiple users, simultaneous execution, and preserved integrity/access.
(e)
6 marks
- Interaction Method 1 — Menu-driven / Form-based filtering:
- 1) Objective: Retrieve a filtered view of authorized medications targeting a specific condition (e.g., influenza).
- 2) Mechanism: The pharmacist navigates a graphical dropdown menu of therapeutic categories and selects 'influenza' to trigger a pre-configured lookup displaying matching drug specifications.
- Interaction Method 2 — Parameterized Query By Example (QBE) / Search Form:
- 1) Objective: Locate suitable pediatric medications matching multiple clinical criteria (e.g., symptom = cough AND patient age < 12).
- 2) Mechanism: The user enters filter parameters directly into labeled form fields, which the interface translates into an underlying SQL SELECT query to return matching records.
- Interaction Method 3 — Visual Report Generation:
- 1) Objective: Produce a formatted, printable summary of all authorized products manufactured by a specific pharmaceutical supplier.
- 2) Mechanism: The pharmacist clicks a report icon and selects a visual report template, prompting the system to query, group, and format the read-only dataset.
Mentor tip
For 6-mark discussion questions on user interaction, detail at least two distinct read-only scenarios covering what is requested, specific filter parameters, and the technical interface mechanism.

