-- Iteration 1 Database Schema
-- Objective: Schema adjustments made to address mapping gaps and missing data requirements identified by the OR expert, with updates to business configuration logic for parameters better suited outside of tables.

CREATE TABLE concert_stadium_mapping (
  concert_ID INTEGER,
  stadium_ID INTEGER
);

CREATE TABLE attendance_coefficients (
  concert_ID INTEGER,
  stadium_ID INTEGER,
  coefficient FLOAT
);

