READ-ONLY DATABASE WORKFLOW EXERCISE
Guide: https://yenra.com/empress-data-management-system-section-508/
Purpose: check whether a small, known result can be read and interpreted through
the actual database client and access tools. Fictional data; no product certification.

Prerequisites: approved test environment, read-only account and a demonstration
table prepared by the environment owner. Adapt syntax to the installed SQL dialect.
Never put credentials or production records in these notes.

Table: access_demo
Columns: branch (text), open_cases (integer)
Rows: East, 12; North, 8; West, 5

Query 1:
SELECT branch, open_cases FROM access_demo ORDER BY branch;
Expected: East = 12; North = 8; West = 5, in that order.
Task: identify West's value, then return to the column headings.

Query 2:
SELECT SUM(open_cases) AS total_open FROM access_demo;
Expected: total_open = 25.

Record: database/client versions, operating system, terminal or GUI, display and
output settings, access tools, starting state, date and observed result.
Check: wrapping, truncation, paging, header association, error recovery and exports.
Use only controlled, non-destructive errors in the approved test environment.
Separate successful tasks, blocked tasks and untested functions. Describe any
barrier with sanitized output and the exact step needed to reproduce it.