Genre

idname
1Action
2Adventure
3Comedy
4Drama
5Fantasy

MediaType

idtypeName
1Film
2Novel

EntertainmentItem

idtitlereleaseYeargenreIdmediaTypeId
(→ Genre.id)(→ MediaType.id)
1Film1202011
2Film2202121
3Novel1202032
4Novel2202142

Author

idfirstNamelastName
1JohnDoe
2JaneSmith

Novel

idauthorIdpublicationYear
(→ Author.id)
112020
222021

Film

iddirectorfilmId
(→ EntertainmentItem.id)
1Director11
2Director22