Political_Reporters
| id | name | email |
| 1 | John Doe | john@example.com |
| 2 | Jane Smith | jane@example.com |
| 3 | Alice Johnson | alice@example.com |
| 4 | Bob Brown | bob@example.com |
| 5 | Charlie Green | charlie@example.com |
Elections
| id | election_type | start_date | end_date |
| 1 | Presidential_Campaigns | 2021-01-01 | 2021-12-31 |
| 2 | Local_Council_elections | 2022-01-01 | 2022-12-31 |
| 3 | State_Assembly_elections | 2023-01-01 | 2023-12-31 |
| 4 | Referendums | 2024-01-01 | 2024-12-31 |
| 5 | By-Elections | 2025-01-01 | 2025-12-31 |
Political_Reporters_Elections
| reporter_id | election_id |
| (→ Political_Reporters.id) | (→ Elections.id) |
| 1 | 1 |
| 1 | 2 |
| 2 | 1 |
| 2 | 3 |
| 3 | 1 |
| 4 | 1 |
| 5 | 1 |