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).
|FDRecID||Numeric (Identity)||Unique films director ID|
FilmsID related to primary key in Films table
DirectorID related to primary key in Directors table