Immigration Management DB

SELECT case_number, expiration_date
FROM documents d
JOIN cases c ON d.case_id = c.case_id
WHERE expiration_date
  BETWEEN NOW() AND NOW() + 30 DAY;

Index on expiration_date enables efficient range scan

SELECT c.case_number, p.first_name,
       cp.role, cp.is_primary
FROM cases c
JOIN case_persons cp ON c.case_id = cp.case_id
JOIN persons p ON cp.person_id = p.person_id;

Junction table enables flexible role assignment