-- Iteration 1 Database Schema
-- Objective: Schema changes include creating new tables for missing optimization data and updating existing tables to fill mapping gaps. Configuration logic updated for scalar parameters and formulas.

CREATE TABLE Participation_Score (
  FacID INTEGER,
  actid INTEGER,
  participation_score FLOAT
);

CREATE TABLE Faculty_Participates_in (
  FacID INTEGER,
  actid INTEGER,
  participation_score FLOAT
);

