All work

System · 2025 · Data & application engineer

CRIS

A cancer research information system: a normalized Oracle schema and a role-aware APEX application for clinical staff.

Open the walkthrough

Seven normalized Oracle tables and a 23-page Oracle APEX application for cancer research data, with role-based access. The analytics view joins those tables and uses CASE logic to show trial enrollment and patient outcome metrics.

  • Oracle
  • APEX
  • SQL