id | Role |
---|---|
1 | Actor |
2 | Director |
id | Name | Birth_year |
---|---|---|
1 | John Doe | 1975 |
2 | Jane Smith | 1980 |
id | Title | Release_date |
---|---|---|
1 | Movie1 | 2000-01-01 |
2 | Movie2 | 2005-06-01 |
MovieId | PersonId | RoleId |
---|---|---|
(→ Movies.id) | (→ People.id) | (→ Roles.id) |
1 | 1 | 1 |
2 | 2 | 1 |
3 | 1 | 2 |
4 | 2 | 2 |
DirectorId | MovieId |
---|---|
(→ People.id) | (→ Movies.id) |
1 | 1 |
2 | 2 |
ActorId | MovieId |
---|---|
(→ People.id) | (→ Movies.id) |
1 | 1 |
2 | 2 |
3 | 3 |
4 | 4 |