-- Iteration 1 Database Schema
-- Objective: Schema adjustments and configuration logic updates were made to address missing optimization requirements and improve mapping adequacy based on OR expert analysis.

CREATE TABLE county_public_safety (
  Crime_rate FLOAT,
  Population INTEGER,
  Residents_per_officer INTEGER,
  Case_burden FLOAT,
  Police_officers INTEGER
);

