-- Iteration 1 Realistic Data
-- Generated by triple expert (business + data + optimization)
-- Values were determined based on typical market values and sales figures for mid-sized companies and realistic building capacities in urban areas.

-- Realistic data for Companies
INSERT INTO Companies (Market_Value_billion, Sales_billion) VALUES (12.0, 6.5);
INSERT INTO Companies (Market_Value_billion, Sales_billion) VALUES (18.0, 8.0);
INSERT INTO Companies (Market_Value_billion, Sales_billion) VALUES (14.5, 7.0);

-- Realistic data for buildings
INSERT INTO buildings (Stories) VALUES (12);
INSERT INTO buildings (Stories) VALUES (18);
INSERT INTO buildings (Stories) VALUES (15);

-- Realistic data for Office_Allocations
INSERT INTO Office_Allocations (building_id, company_id) VALUES (1, 101);
INSERT INTO Office_Allocations (building_id, company_id) VALUES (2, 102);
INSERT INTO Office_Allocations (building_id, company_id) VALUES (3, 103);

