## Costume_Designers

id | name | birthdate
--- | --- | ---
1 | John Smith | 1960-07-23
2 | Jane Doe | 1980-09-15
3 | Michael Brown | 1990-11-30
4 | Emily Davis | 1995-02-22
5 | David Johnson | 1970-05-01

## Eras

id | era_name
--- | ---
1 | Victorian Era
2 | Modern Era
3 | Renaissance
4 | Baroque
5 | Gothic

## Film_Projects

id | title | release_year | director
--- | --- | --- | ---
1 | Film A | 2000 | Alice Cooper
2 | Film B | 2005 | Bob Evans
3 | Film C | 2010 | Carol King
4 | Film D | 2015 | Dave Lee
5 | Film E | 2020 | Edward Wright

## Films_and_Directors

film_id | director_id
--- | ---
(→ Film_Projects.id) | (→ Directors.id)
1 | 1
2 | 2
3 | 3
4 | 4
5 | 5

## Actors

id | first_name | last_name
--- | --- | ---
1 | Alex | Adams
2 | Ben | Blake
3 | Chris | Cooper
4 | Daniel | Dean
5 | Ethan | Edwards

## Roles

role_id | actor_id | character_name
--- | --- | ---
| (→ Actors.id) |
1 | 1 | Role A
2 | 2 | Role B
3 | 3 | Role C
4 | 4 | Role D
5 | 5 | Role E

## Films_and_Actors

film_id | actor_id
--- | ---
(→ Film_Projects.id) | (→ Actors.id)
1 | 1
1 | 2
2 | 3
3 | 4
4 | 5

## Directors

id | first_name | last_name
--- | --- | ---
1 | Mark | Wood
2 | Nick | Hopkins
3 | Samantha | Green
4 | Tommy | Carter
5 | Paul | Evans

## Costume_Designers_Eras

costume_designer_id | eras_id
--- | ---
(→ Costume_Designers.id) | (→ Eras.id)
1 | 1
2 | 2
3 | 3
4 | 4
5 | 5
2 | 1
3 | 1
4 | 1
5 | 1