September 2007
Intermediate to advanced
600 pages
20h 21m
English
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 |
| Description | Text | Expense description |
| ExpenseDate | Date | Expense date |
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.
Read now
Unlock full access