-- Iteration 1 Database Schema
-- Objective: Schema changes include creating new tables for missing optimization data, modifying existing tables to fill mapping gaps, and updating business configuration logic for scalar parameters and formulas.

CREATE TABLE Song (
  SongID INTEGER,
  PotentialSalesIncrease FLOAT
);

CREATE TABLE PromotionCost (
  SongID INTEGER,
  Cost FLOAT,
  Promote BOOLEAN
);

