## Locations_Managers

id | name | contact_info
--- | --- | ---
1 | John Doe | +1234567890
2 | Jane Smith | +9876543210
3 | Alice Johnson | +1112223330
4 | Bob Brown | +4445556660
5 | Charlie Davis | +7778889990

## Responsibilities

id | description
--- | ---
1 | Film Permit Acquisition
2 | Location Scouting
3 | Health & Safety Compliance
4 | Contract Negotiation
5 | Equipment Coordination

## Locations_Managers_Responsibilities

locations_manager_id | responsibility_id
--- | ---
(→ Locations_Managers.id) | (→ Responsibilities.id)
1 | 1
2 | 1
3 | 1
4 | 1
5 | 1
5 | 5

## Film_Crews

id | crew_name | role
--- | --- | ---
1 | Camera Team | Director of Photography
2 | Sound Team | Boom Operator
3 | Production Designers | Art Director
4 | Costume Department | Costumer
5 | Special Effects | Pyrotechnics Specialist

## Movie_Projects

id | title | release_date | budget
--- | --- | --- | ---
1 | The Big Adventure | 2022-12-01 | 10000000.0
2 | Alien Invasion | 2023-06-15 | 15000000.0
3 | Love Story | 2024-02-14 | 5000000.0
4 | Action Thriller | 2025-08-20 | 20000000.0
5 | Comedy Drama | 2026-04-01 | 7000000.0

## Movies_Cast

movie_id | actor_id | character_name
--- | --- | ---
(→ Movie_Projects.id) | (→ Actors.id) |
1 | 1 | Hero
1 | 2 | Villain
2 | 3 | Lead Scientist
2 | 4 | Intergalactic Warrior
3 | 5 | Lonely Heart
3 | 6 | Business Tycoon
4 | 7 | Detective
4 | 8 | Gang Leader
5 | 9 | Small Town Girl
5 | 10 | Wise Old Man

## Directors

id | director_name | birth_year
--- | --- | ---
1 | Samuel L Jackson | 1948
2 | Denzel Washington | 1954
3 | Tom Hanks | 1956
4 | Robert De Niro | 1943
5 | Anthony Hopkins | 1937

## Directed_Movies

director_id | movie_id
--- | ---
(→ Directors.id) | (→ Movie_Projects.id)
1 | 1
2 | 2
3 | 3
4 | 4
5 | 5