| reporter_id | full_name |
|---|---|
| 1 | John Doe |
| 2 | Jane Smith |
| 3 | Alex Brown |
| 4 | Emily Green |
| 5 | William Black |
| mission_id | mission_name |
|---|---|
| 1 | Mars_Exploration |
| 2 | Lunar_Exploration |
| 3 | Asteroid_Study |
| 4 | Planetary_Research |
| 5 | Deep_Space_Probes |
| 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 |