-- Iteration 2 Realistic Data
-- Generated by triple expert (business + data + optimization)
-- Values were determined based on typical workload capacities for editors and realistic sales figures for journals in a mid-sized publishing company.

-- Realistic data for journal_committee
INSERT INTO journal_committee (Editor_ID, Journal_ID) VALUES (1, 101);
INSERT INTO journal_committee (Editor_ID, Journal_ID) VALUES (2, 102);
INSERT INTO journal_committee (Editor_ID, Journal_ID) VALUES (3, 103);

-- Realistic data for editor_qualifications
INSERT INTO editor_qualifications (Editor_ID, Theme) VALUES (1, 'Science');
INSERT INTO editor_qualifications (Editor_ID, Theme) VALUES (2, 'Arts');
INSERT INTO editor_qualifications (Editor_ID, Theme) VALUES (3, 'Technology');

-- Realistic data for journal_sales
INSERT INTO journal_sales (Journal_ID, Sales) VALUES (101, 1200.0);
INSERT INTO journal_sales (Journal_ID, Sales) VALUES (102, 1800.0);
INSERT INTO journal_sales (Journal_ID, Sales) VALUES (103, 1600.0);

