## Directors

DirectorID | Name | BirthDate | Nationality
--- | --- | --- | ---
1 | John Doe | 1968-07-23 | American
2 | Jane Smith | 1970-03-10 | Canadian

## Producers

ProducerID | Name | ContactNumber | Email | AssociatedDirector
--- | --- | --- | --- | ---
|  |  |  | (→ Directors.DirectorID)
1 | Alice Brown | +1234567890 | ab@email.com | 1
2 | Charlie Green | +0987654321 | cg@email.com | 2

## Films

FilmID | Title | ReleaseYear | FilmType | Budget | ProductionCompanyID
--- | --- | --- | --- | --- | ---
|  |  |  |  | (→ Companies.CompanyID)
1 | The Documentary | 2000 | Documentary | 500000.0 | 1
2 | Another Doc | 2001 | Documentary | 750000.0 | 1
3 | A Short Film | 2002 | Short Film | 500000.0 | 2
4 | Yet Another Short | 2003 | Short Film | 300000.0 | 2

## Actors

ActorID | FirstName | LastName | DateOfBirth
--- | --- | --- | ---
1 | Tom | Hanks | 1956-07-09
2 | Meryl | Streep | 1949-06-22

## Casts

RoleID | FilmID | ActorID | CharacterName | AppearanceFee
--- | --- | --- | --- | ---
| (→ Films.FilmID) | (→ Actors.ActorID) |  |
1 | 1 | 1 | Main Lead | 100000
2 | 2 | 2 | Supporting Role | 50000

## Companies

CompanyID | CompanyName | AddressLine1 | AddressLine2 | City | StateOrRegion | PostalCode | Country
--- | --- | --- | --- | --- | --- | --- | ---
1 | Big Movie Co. | 123 Main St. |  | New York | NY | 10001 | USA
2 | Small Indie Studio | 456 Elm Rd. |  | Los Angeles | CA | 90001 | USA