Stars

idname
1Mia Zhang
2John Doe
3Jane Smith
4Alice Johnson
5Bob Brown

Western_Movies

idtitlerelease_yearstar_id
(→ Stars.id)
1The Good, The Bad and The Ugly19661
2Once Upon a Time in the West19682
3A Fistful of Dollars19643
4For a Few Dollars More19654
5High Plains Drifter19735

Science_Fiction_Movies

idtitlerelease_yearstar_id
(→ Stars.id)
1Blade Runner19821
2Alien19792
3Star Wars19773
4Eternal Sunshine of the Spotless Mind20044
5Inception20105

Actors

idfirst_namelast_namebirthdate
1ClintEastwood1930-05-31
2HenryFonda1905-18-16
3LeeVan Cleef1925-01-9
4CharlesBronson1921-11-03
5SergioLeone1929-01-03

Roles

idmovie_titleactor_idcharacter_name
(→ Actors.id)
1The Good, The Bad and The Ugly1Monco
2Once Upon a Time in the West2Harmonica
3A Fistful of Dollars3Joe
4For a Few Dollars More4Colonel Douglas Mortimer
5High Plains Drifter5Nathan Burdette

Movie_Genres

idgenre_typedescription
1Action & AdventureExciting stories full of action and adventure.
2DramaFilms that focus on realistic characters and situations.
3ComedyFunny movies meant to entertain and make people laugh.
4RomanceLove stories focusing on relationships between two people.
5HorrorScary films intended to frighten viewers.

Movies

idtitlerelease_yeargenre_id
(→ Movie_Genres.id)
1The Good, The Bad and The Ugly19661
2Once Upon a Time in the West19682
3A Fistful of Dollars19643
4For a Few Dollars More19654
5High Plains Drifter19735