Secure Healthcare Database Design with Access and SQL
A relational healthcare data model designed for integrity, controlled access, auditability, and downstream analysis.
The challenge
What needed to be solved
Represent interconnected clinical and access information in a structure that protects relationships, supports auditing, and remains useful for analysis.
The approach
How I worked through it
I translated a partial data dictionary into tables and relationships, prototyped the model visually, then rebuilt it through SQL to control keys, constraints, and data operations precisely.
The result
What the work demonstrated
The resulting schema connected patient, health record, user, role, audit, access, and sharing data with enforced relationships and a clear path to reporting.
Process
From problem to validation
Interpret the data dictionary
Identified the core entities, fields, data types, keys, constraints, and relationships required by the healthcare scenario.
Prototype the model
Built the tables and relationships in Microsoft Access to test how the entities interacted.
Rebuild with SQL
Recreated the schema with CREATE TABLE statements, primary and foreign keys, referential integrity, and CRUD operations.
Prepare for analysis
Populated the model with sample data and connected it to Power BI for demographic, access-role, and health-record insights.
Evidence
Implementation and validation
Skills demonstrated