## Producer

id | name | email
--- | --- | ---
1 | John Doe | johndoe@example.com
2 | Jane Smith | janesmith@example.com
3 | Tom Johnson | tomjohnson@example.com

## Director

id | name | birth_date
--- | --- | ---
1 | Alice Brown | 1980-06-23
2 | Bob White | 1975-10-08
3 | Carol Black | 1990-02-22

## Category

id | category_name
--- | ---
1 | Current Affairs
2 | Politics
3 | History
4 | Culture
5 | Technology

## Documentary

id | title | release_year | producer_id | director_id | category_id
--- | --- | --- | --- | --- | ---
|  |  | (→ Producer.id) | (→ Director.id) | (→ Category.id)
1 | The Rise of Fascism | 2019 | 1 | 3 | 1
2 | Inside North Korea | 2018 | 2 | 2 | 3
3 | Revolutionizing Technology | 2020 | 3 | 1 | 5
4 | The Art of War | 2017 | 1 | 3 | 4
5 | Climate Change Crisis | 2021 | 2 | 1 | 2

## Journalist

id | journalist_name | email | documentary_id | role
--- | --- | --- | --- | ---
|  |  | (→ Documentary.id) |
1 | Michael Lee | mlee@example.com | 1 | Reporter
2 | Emily Davis | edavis@example.com | 2 | Production Assistant
3 | David Williams | dwilliams@example.com | 3 | Interviewer
4 | Rachel Thompson | rthompson@example.com | 4 | Researcher
5 | Kevin Wright | kwright@example.com | 5 | Presenter