-- Iteration 1 Realistic Data
-- Generated by triple expert (business + data + optimization)
-- Values were determined based on typical manufacturing capacities and product pricing strategies to ensure a realistic and solvable optimization problem.

-- Realistic data for Products
INSERT INTO Products (Price, ProductionQuantity) VALUES (12.99, 150);
INSERT INTO Products (Price, ProductionQuantity) VALUES (18.49, 250);
INSERT INTO Products (Price, ProductionQuantity) VALUES (22.0, 200);

-- Realistic data for ProductionQuantities
INSERT INTO ProductionQuantities (ProductID, Quantity) VALUES (1, 150);
INSERT INTO ProductionQuantities (ProductID, Quantity) VALUES (2, 250);
INSERT INTO ProductionQuantities (ProductID, Quantity) VALUES (3, 200);

-- Realistic data for Manufacturers
INSERT INTO Manufacturers (ManufacturerID, Capacity) VALUES (1, 5000);
INSERT INTO Manufacturers (ManufacturerID, Capacity) VALUES (2, 7000);
INSERT INTO Manufacturers (ManufacturerID, Capacity) VALUES (3, 8000);

