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

CREATE TABLE Has_Pet (
  StuID INTEGER,
  PetID INTEGER,
  AdvisorID INTEGER
);

CREATE TABLE AdvisorConstraints (
  AdvisorID INTEGER,
  MaxStudents INTEGER,
  MaxWeight FLOAT
);

CREATE TABLE PetWeightAssignment (
  AdvisorID INTEGER,
  TotalPetWeight FLOAT
);

