-- Iteration 2 Database Schema
-- Objective: Added Date_Claim_Received column to Claims table to address missing data requirement for settlement period calculation. Updated business configuration logic for max_settlement_period.

CREATE TABLE Claims (
  Amount_Settled FLOAT,
  Amount_Claimed FLOAT,
  Date_Claim_Settled DATE,
  Date_Claim_Received DATE
);

