## Stars

id | name
--- | ---
1 | Mia Zhang
2 | John Doe
3 | Jane Smith
4 | Alice Johnson
5 | Bob Brown

## Western_Movies

id | title | release_year | star_id
--- | --- | --- | ---
|  |  | (→ Stars.id)
1 | The Good, The Bad and The Ugly | 1966 | 1
2 | Once Upon a Time in the West | 1968 | 2
3 | A Fistful of Dollars | 1964 | 3
4 | For a Few Dollars More | 1965 | 4
5 | High Plains Drifter | 1973 | 5

## Science_Fiction_Movies

id | title | release_year | star_id
--- | --- | --- | ---
|  |  | (→ Stars.id)
1 | Blade Runner | 1982 | 1
2 | Alien | 1979 | 2
3 | Star Wars | 1977 | 3
4 | Eternal Sunshine of the Spotless Mind | 2004 | 4
5 | Inception | 2010 | 5

## Actors

id | first_name | last_name | birthdate
--- | --- | --- | ---
1 | Clint | Eastwood | 1930-05-31
2 | Henry | Fonda | 1905-18-16
3 | Lee | Van Cleef | 1925-01-9
4 | Charles | Bronson | 1921-11-03
5 | Sergio | Leone | 1929-01-03

## Roles

id | movie_title | actor_id | character_name
--- | --- | --- | ---
|  | (→ Actors.id) |
1 | The Good, The Bad and The Ugly | 1 | Monco
2 | Once Upon a Time in the West | 2 | Harmonica
3 | A Fistful of Dollars | 3 | Joe
4 | For a Few Dollars More | 4 | Colonel Douglas Mortimer
5 | High Plains Drifter | 5 | Nathan Burdette

## Movie_Genres

id | genre_type | description
--- | --- | ---
1 | Action & Adventure | Exciting stories full of action and adventure.
2 | Drama | Films that focus on realistic characters and situations.
3 | Comedy | Funny movies meant to entertain and make people laugh.
4 | Romance | Love stories focusing on relationships between two people.
5 | Horror | Scary films intended to frighten viewers.

## Movies

id | title | release_year | genre_id
--- | --- | --- | ---
|  |  | (→ Movie_Genres.id)
1 | The Good, The Bad and The Ugly | 1966 | 1
2 | Once Upon a Time in the West | 1968 | 2
3 | A Fistful of Dollars | 1964 | 3
4 | For a Few Dollars More | 1965 | 4
5 | High Plains Drifter | 1973 | 5