## Writer

id | Name | Type | Education
--- | --- | --- | ---
1 | John Doe | Screenwriter | New York University
2 | Jane Smith | Screenwriter | University of California Los Angeles
3 | Bob Johnson | Playwright | New York University
4 | Alice Brown | Playwright | Columbia University
5 | Tom Green | Screenwriter | American Film Institute
6 | Mary White | Director | UCLA School of Theater, Film and Television

## Film

id | Title | ReleaseYear | Genre
--- | --- | --- | ---
1 | Inception | 2010 | Science Fiction
2 | The Matrix | 1999 | Science Fiction
3 | Fight Club | 1999 | Drama
4 | Pulp Fiction | 1994 | Crime
5 | Goodfellas | 1990 | Crime

## Director

id | Name | BirthDate
--- | --- | ---
1 | Christopher Nolan | 30 July 1970
2 | Lana Wachowski | 21 June 1968
3 | David Fincher | August 22, 1962
4 | Quentin Tarantino | March 27, 1963
5 | Martin Scorsese | November 17, 1942

## Director_Film

directorId | filmId
--- | ---
(→ Director.id) | (→ Film.id)
1 | 1
2 | 2
3 | 3
4 | 4
5 | 5

## Screenplay

id | Title | Year
--- | --- | ---
1 | Inception | 1
2 | The Matrix | 2
3 | Fight Club | 3
4 | Pulp Fiction | 4
5 | Goodfellas | 5

## Film_Screenplay

filmId | scriptId
--- | ---
(→ Film.id) | (→ Script.id)
1 | 1
2 | 2
3 | 3
4 | 4
5 | 5