The Directors table (Table 5.4) contains the list of directors. This table is related to the Films table via the FilmsDirectors table.
|Column||Data Type||Description and Size|
|DirectorID||Numeric||Unique ID for each director; can be populated manually when rows are inserted or automatically (if defined as an Auto Number field)|
|FirstName||Text||Director’s first name|
|LastName||Text||Director’s last name|
The primary key for this table is the DirectorID column.
This table contains no foreign keys.