The FilmsDirectors Table
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 |
Primary Key
FDRecID
Foreign Keys
FilmsID related to primary key in Films table
DirectorID related to primary key in Directors table
Get Adobe ColdFusion 8 Web Application Construction Kit, Volume 1: Getting Started now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
