-- Iteration 2 Database Schema
-- Objective: Schema changes include creating a new table for years of experience mismatch and updating existing tables to fill mapping gaps. Business configuration logic is updated to handle scalar parameters and formulas.

CREATE TABLE DriverAssignments (
  DriverID INTEGER,
  SchoolID INTEGER,
  Assigned BOOLEAN
);

CREATE TABLE SchoolRequirements (
  SchoolID INTEGER,
  RequiredDrivers INTEGER
);

CREATE TABLE Drivers (
  DriverID INTEGER,
  IsFullTime BOOLEAN
);

CREATE TABLE ExperienceMismatch (
  DriverID INTEGER,
  SchoolID INTEGER,
  YearsMismatch INTEGER
);

