The FilmsDirectors table (Table 5.5) is used to relate the Films and Directors tables (so as to associate directors with their movies).
|Column||Data Type||Description and Size|
|FDRecID||Numeric||Unique ID for each row; can be populated manually when rows are inserted or automatically (if defined as an Auto Number field)|
|FilmID||Numeric||ID of associated movie|
|DirectorID||Numeric||ID of associated director|
|Salary||Numeric, or currency||Director’s salary|
The primary key for this table is the FDRecID column.
This table contains two foreign keys:
The FilmID column is related to the primary key of the Films table.
The DirectorID column is related to the primary key of the Directors table.