Media

idEntertainment_TypeRelease_YearDurationRating
1Film20201807.3
2Film20191206.2
3Novel2020None4.5
4Novel2019None3.8
5FilmDrama1508.2

Authors

idNameBirthdateNationality
1John Smith1990-05-01USA
2Jane Doe1992-01-01UK
3Michael Johnson1987-10-01Canada
4Emily Davis1991-09-01Australia
5William Brown1989-07-01Ireland

Novels

idTitleAuthorIdGenre
(→ Authors.id)
1The Great Escape1Adventure
2A Tale of Two Cities2Historical Fiction
3The Da Vinci Code3Thriller
4Gone Girl4Psychological Thriller
5To Kill a Mockingbird5Classic Literature

FilmDirectors

idNameBirthdateNationality
1Alice Johnson1975-02-01USA
2David Williams1980-08-01UK
3Lucy Wilson1985-04-01Canada
4Mark Thompson1990-10-01Australia
5Steven Clark1988-06-01Ireland

Films

idTitleDirectorIdYearReleasedBudgetRevenue
(→ FilmDirectors.id)
1Inception12010160829
2Interstellar22014180677
3Avatar320092802847
4Black Panther420182001619
5Frozen520131501277

Actors

idFirstNameLastNameDateOfBirth
1TomHanks1956-07-09
2LeonardoDiCaprio1974-11-11
3ScarlettJohansson1984-11-22
4ChrisEvans1981-05-13
5DaisyRidley1992-04-10

CastMembers

idActorIdFilmIdRole
(→ Actors.id)(→ Films.id)
111Protagonist
222Villain
333Lead Heroine
444Antagonist
555Sidekick