The Expenses table (Table 5.3) contains the expenses associated with any movies listed in the Films table.
|Column||Data Type||Description and Size|
|ExpenseID||Numeric||Unique ID for each expense; can be populated manually when rows are inserted or automatically (if defined as an Auto Number field)|
|FilmID||Numeric||ID of associated movie|
|ExpenseAmount||Numeric, or currency||Expense amount|
The primary key for this table is the ExpenseID column.
This table contains a single foreign key:
The FilmID column is related to the primary key of the Films table.