## Genre

id | name
--- | ---
1 | Action
2 | Adventure
3 | Comedy
4 | Drama
5 | Fantasy

## MediaType

id | typeName
--- | ---
1 | Film
2 | Novel

## EntertainmentItem

id | title | releaseYear | genreId | mediaTypeId
--- | --- | --- | --- | ---
|  |  | (→ Genre.id) | (→ MediaType.id)
1 | Film1 | 2020 | 1 | 1
2 | Film2 | 2021 | 2 | 1
3 | Novel1 | 2020 | 3 | 2
4 | Novel2 | 2021 | 4 | 2

## Author

id | firstName | lastName
--- | --- | ---
1 | John | Doe
2 | Jane | Smith

## Novel

id | authorId | publicationYear
--- | --- | ---
| (→ Author.id) |
1 | 1 | 2020
2 | 2 | 2021

## Film

id | director | filmId
--- | --- | ---
|  | (→ EntertainmentItem.id)
1 | Director1 | 1
2 | Director2 | 2