-- Iteration 2 Database Schema
-- Objective: Schema adjustments were made to incorporate missing yellow card data and improve optimization mapping. Configuration logic was updated to include scalar parameters and formulas.

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

CREATE TABLE PositionRequirements (
  position STRING,
  required_players INTEGER
);

CREATE TABLE CollegeLimits (
  college STRING,
  max_players INTEGER
);

CREATE TABLE PlayerYellowCards (
  pID INTEGER,
  yCard INTEGER
);

