September 2007
Intermediate to advanced
600 pages
20h 21m
English
The FilmsActors table associates actors with the movies they are in. FilmsActors contains the columns in Table B.6. Retrieving actors with their movies requires a three-way join (Films, Actors, and FilmsActors).
| Column | Datatype | Description |
|---|---|---|
| FARecID | Numeric (Identity) | Unique film actor ID |
| FilmID | Numeric | Movie ID |
| ActorID | Numeric | Actor ID |
| IsStarringRole | Small Integer | Is star flag |
| Salary | Real | Actor salary |
FARecID
FilmID related to primary key in Films table
ActorID related to primary key in Actors table
Read now
Unlock full access