Movie Database
This database features two entities (movies and actors) in a
many-to-many relation. Each entity has its own table. A third
table,
casting
, is used to link them. The relationship is many-to-many because
each film features many actors and each actor has appeared in
many films.
movie
| Field name |
Type |
Notes |
| id |
INTEGER |
An arbitrary unique identifier |
| title |
CHAR(70) |
The name of the film - usually in the language of the
first release. |
| yr |
DECIMAL(4) |
Year of first release. |
| director |
INT |
A reference to the actor table. |
| budget |
INTEGER |
How much the movie cost to make (in a variety of currencies unfortunately). |
| gross |
INTEGER |
How much the movie made at the box office. |
Example
| id | title | yr | director | budget | gross |
|---|
| 10003 | "Crocodile" Dundee II | 1988 | 38 | 15800000 | 239606210 |
| 10004 | 'Til There Was You | 1997 | 49 | 10000000 | |
actor
| Field name |
Type |
Notes |
| id |
INTEGER |
An arbitrary unique identifier |
| name |
CHAR(36) |
The name of the actor (the term actor is used to refer to
both male and female thesps.) |
Example
| id | name |
|---|
| 20 | Paul Hogan |
| 50 | Jeanne Tripplehorn |
casting
| Field name |
Type |
Notes |
| movieid |
INTEGER |
A reference to the movie table. |
| actorid |
INTEGER |
A reference to the actor table. |
| ord |
INTEGER |
The ordinal position of the actor in the cast list. The
star of the movie will have ord value 1 the co-star will have
value 2, ... |
Example
| movieid | actorid | ord |
|---|
| 10003 | 20 | 4 |
| 10004 | 50 | 1 |
