## company

id | name | type | Number_of_employees
--- | --- | --- | ---
1 | Big Studio | Production Company | 500
2 | Small Studio | Production Company | 300
3 | Mega Distribution | Distribution Company | 500
4 | Local Distribution | Distribution Company | 200
5 | Techno Films | Post Production Company | 75

## director

id | first_name | last_name | birth_date | nationality
--- | --- | --- | --- | ---
1 | John | Smith | 1968-05-15 | USA
2 | Jane | Doe | 1982-03-23 | Canada
3 | Alice | Brown | 1975-08-05 | UK
4 | Bob | White | 1990-10-10 | Australia
5 | Charlie | Black | 1955-01-12 | New Zealand

## actor

id | first_name | last_name | birth_date | gender
--- | --- | --- | --- | ---
1 | Tom | Hanks | 1956-07-09 | M
2 | Robert | De Niro | 1943-08-17 | M
3 | Meryl | Streep | 1949-06-22 | F
4 | Julia | Roberts | 1967-10-28 | F
5 | Will | Smith | 1968-09-25 | M

## film

id | title | release_year | genre | production_id | director_id | Film_industry_company
--- | --- | --- | --- | --- | --- | ---
|  |  |  | (→ company.id) | (→ director.id) |
1 | The Shawshank Redemption | 1994 | Drama | 1 | 1 | Production Company
2 | Pulp Fiction | 1994 | Crime | 2 | 2 | Production Company
3 | Inception | 2010 | Action | 3 | 3 | Distribution Company
4 | Interstellar | 2014 | Adventure | 4 | 4 | Distribution Company
5 | Avatar | 2009 | Science fiction | 5 | 5 | Post Production Company