-- Iteration 2 Database Schema
-- Objective: Incorporated stadium capacity data into the schema, addressed mapping gaps, and updated business configuration logic for scalar parameters and formulas.

CREATE TABLE concert_stadium_mapping (
  concert_ID INTEGER,
  stadium_ID INTEGER
);

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

CREATE TABLE stadium_capacity (
  stadium_ID INTEGER,
  capacity INTEGER
);

