War_Correspondents
| id | name | organization |
| 1 | John Smith | ABC News |
| 2 | Jane Doe | CNN |
| 3 | Michael Brown | Fox News |
| 4 | Emily Johnson | BBC |
| 5 | David Wilson | Al Jazeera |
Locations
| id | locationName |
| 1 | Battlefield |
| 2 | Capital City |
| 3 | Refugee Camp |
| 4 | Military Base |
| 5 | Government Building |
War_Correspondents_Locations
| warCorrespondentId | locationId | assignmentDate |
| (→ War_Correspondents.id) | (→ Locations.id) | |
| 1 | 1 | 2023-01-01 |
| 1 | 2 | 2023-02-01 |
| 2 | 1 | 2023-03-01 |
| 2 | 3 | 2023-04-01 |
| 3 | 2 | 2023-05-01 |
| 3 | 4 | 2023-06-01 |
| 4 | 1 | 2023-07-01 |
| 4 | 5 | 2023-08-01 |
| 5 | 3 | 2023-09-01 |
| 5 | 4 | 2023-10-01 |
| 3 | 1 | 2023-05-01 |
| 5 | 1 | 2023-09-01 |