| 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 |