advancedTop 15 Database Design Questions

Design a healthcare appointment system with HIPAA compliance.

patients(id UUID PK, name_encrypted BYTEA, ssn_encrypted BYTEA, dob DATE, created_at) — encrypt PII at application level doctors(id, license_number UNIQUE, specialty, department_id FK) appointments(id, patient_id FK, doctor_id FK, scheduled_at TIMESTAMPTZ, status, notes_encrypted BYTEA) audit_log: every SELECT/INSERT/UPDATE/DELETE logged with user_id, patient_id, timestamp, action Row-Level Securi

This is a Pro chapter

Sign in, then upgrade to Pro or Power to unlock this and the full Databases Mastery library.

Design a healthcare appointment system with HIPAA compliance.

Next Step

Continue to Design a URL shortener database handling 100,000 URL redirects per second.← Back to all SQL questions