## Space_Reporters

reporter_id | full_name
--- | ---
1 | John Doe
2 | Jane Smith
3 | Alex Brown
4 | Emily Green
5 | William Black

## Missions

mission_id | mission_name
--- | ---
1 | Mars_Exploration
2 | Lunar_Exploration
3 | Asteroid_Study
4 | Planetary_Research
5 | Deep_Space_Probes

## Space_Reporters_Missions

space_reporter_id | mission_id | assignment_date
--- | --- | ---
(→ Space_Reporters.reporter_id) | (→ Missions.mission_id) |
1 | 1 | 2031-07-01
2 | 2 | 2032-12-01
3 | 3 | 2033-06-01
4 | 4 | 2034-11-01
5 | 5 | 2035-05-01
2 | 1 | 2032-12-01
3 | 1 | 2033-06-01
4 | 1 | 2034-11-01
5 | 1 | 2035-05-01