-- Iteration 2 Database Schema
-- Objective: Incorporated actor ages into the schema to complete the linear formulation and updated business configuration logic for scalar parameters.

CREATE TABLE musical_requirements (
  musical_id INTEGER,
  required_actors INTEGER
);

CREATE TABLE actor_musical_assignment (
  actor_id INTEGER,
  musical_id INTEGER,
  assignment BOOLEAN
);

CREATE TABLE actor_details (
  actor_id INTEGER,
  age INTEGER
);

