-- Iteration 1 Database Schema
-- Objective: Schema adjustments were made to address missing data requirements and improve optimization mapping. Configuration logic was updated to include scalar parameters and formulas.

CREATE TABLE Tryout (
  pID INTEGER,
  pPos STRING,
  cName STRING
);

CREATE TABLE PositionRequirements (
  position STRING,
  required_players INTEGER
);

CREATE TABLE CollegeLimits (
  college STRING,
  max_players INTEGER
);

