September 2007
Intermediate to advanced
600 pages
20h 21m
English
The FilmsDirectors table associates directors with their movies. FilmsDirectors contains the columns in Table B.7. Retrieving actors with their movies requires a three-way join (Films, Directors, and FilmsDirectors).
| Column | Datatype | Description |
|---|---|---|
| FDRecID | Numeric (Identity) | Unique films director ID |
| FilmID | Numeric | Movie ID |
| DirectorID | Numeric | Director ID |
| Salary | Real | Director salary |
FDRecID
FilmsID related to primary key in Films table
DirectorID related to primary key in Directors table
Read now
Unlock full access