-- Iteration 1 Realistic Data
-- Generated by triple expert (business + data + optimization)
-- Values were determined based on typical retail scenarios where device allocation is influenced by shop capacity and potential sales. The values ensure a balance between demand and supply, reflecting realistic business operations.

-- Realistic data for PotentialSales
INSERT INTO PotentialSales (shop_id, device_id, potential_sales) VALUES (1, 101, 600.0);
INSERT INTO PotentialSales (shop_id, device_id, potential_sales) VALUES (2, 102, 850.0);
INSERT INTO PotentialSales (shop_id, device_id, potential_sales) VALUES (3, 103, 950.0);

-- Realistic data for ShopCapacity
INSERT INTO ShopCapacity (shop_id, capacity) VALUES (1, 120);
INSERT INTO ShopCapacity (shop_id, capacity) VALUES (2, 180);
INSERT INTO ShopCapacity (shop_id, capacity) VALUES (3, 220);

-- Realistic data for Allocation
INSERT INTO Allocation (shop_id, device_id, quantity) VALUES (1, 101, 30);
INSERT INTO Allocation (shop_id, device_id, quantity) VALUES (2, 102, 50);
INSERT INTO Allocation (shop_id, device_id, quantity) VALUES (3, 103, 70);

