-- Iteration 2 Realistic Data
-- Generated by triple expert (business + data + optimization)
-- Values were determined based on typical age ranges for actors and realistic casting requirements for musicals, ensuring a diverse age distribution and varied musical requirements.

-- Realistic data for musical_requirements
INSERT INTO musical_requirements (musical_id, required_actors) VALUES (1, 3);
INSERT INTO musical_requirements (musical_id, required_actors) VALUES (2, 4);
INSERT INTO musical_requirements (musical_id, required_actors) VALUES (3, 5);

-- Realistic data for actor_musical_assignment
INSERT INTO actor_musical_assignment (actor_id, musical_id, assignment) VALUES (101, 1, True);
INSERT INTO actor_musical_assignment (actor_id, musical_id, assignment) VALUES (102, 2, True);
INSERT INTO actor_musical_assignment (actor_id, musical_id, assignment) VALUES (103, 3, True);
INSERT INTO actor_musical_assignment (actor_id, musical_id, assignment) VALUES (104, 2, False);
INSERT INTO actor_musical_assignment (actor_id, musical_id, assignment) VALUES (105, 3, False);

-- Realistic data for actor_details
INSERT INTO actor_details (actor_id, age) VALUES (101, 25);
INSERT INTO actor_details (actor_id, age) VALUES (102, 30);
INSERT INTO actor_details (actor_id, age) VALUES (103, 35);

