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 |