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

CREATE TABLE Catalog_Contents (
  price_in_dollars FLOAT,
  price_in_euros FLOAT,
  price_in_pounds FLOAT,
  minimum_price_dollars FLOAT,
  minimum_price_euros FLOAT,
  minimum_price_pounds FLOAT
);

CREATE TABLE Product_Sales (
  product_id INTEGER,
  sales_volume INTEGER
);

CREATE TABLE Stock_Availability (
  product_id INTEGER,
  stock_available INTEGER
);

