-- Iteration 1 Database Schema
-- Objective: Schema changes include creating new tables for decision variables and constraint bounds, modifying existing tables to improve mapping adequacy, and updating business configuration logic for scalar parameters and formulas.

CREATE TABLE teacher_course_assignment (
  Course_ID INTEGER,
  Teacher_ID INTEGER,
  assignment BOOLEAN
);

CREATE TABLE grade_improvement (
  Course_ID INTEGER,
  Teacher_ID INTEGER,
  expected_improvement FLOAT
);

