-- Iteration 2 Realistic Data
-- Generated by triple expert (business + data + optimization)
-- Values were determined based on typical retail scenarios, considering product demand, store capacity, and sales potential. The approach ensures that the data reflects realistic business operations and constraints.

-- Realistic data for ProductSalesValue
INSERT INTO ProductSalesValue (product_id, sales_value) VALUES (1, 12.5);
INSERT INTO ProductSalesValue (product_id, sales_value) VALUES (2, 25.0);
INSERT INTO ProductSalesValue (product_id, sales_value) VALUES (3, 18.0);

-- Realistic data for ProductAvailability
INSERT INTO ProductAvailability (product_id, availability) VALUES (1, 60);
INSERT INTO ProductAvailability (product_id, availability) VALUES (2, 80);
INSERT INTO ProductAvailability (product_id, availability) VALUES (3, 70);

-- Realistic data for Store
INSERT INTO Store (store_id, store_capacity) VALUES (1, 120);
INSERT INTO Store (store_id, store_capacity) VALUES (2, 180);
INSERT INTO Store (store_id, store_capacity) VALUES (3, 150);

-- Realistic data for ProductDistribution
INSERT INTO ProductDistribution (store_id, product_id, units_assigned) VALUES (1, 1, 20);
INSERT INTO ProductDistribution (store_id, product_id, units_assigned) VALUES (2, 2, 40);
INSERT INTO ProductDistribution (store_id, product_id, units_assigned) VALUES (3, 3, 30);

