-- Iteration 1 Database Schema
-- Objective: Schema changes include creating new tables for missing constraint bounds, modifying existing tables to improve mapping adequacy, and updating business configuration logic for scalar parameters and formulas.

CREATE TABLE festival_detail (
  Num_of_Audience INTEGER
);

CREATE TABLE nomination (
  Result BOOLEAN
);

CREATE TABLE artwork_constraints (
  max_nominations INTEGER
);

CREATE TABLE festival_constraints (
  max_capacity INTEGER
);

