September 2007
Intermediate to advanced
600 pages
20h 21m
English
The Expenses table lists the expenses associated with listed movies. Expenses contains the columns in Table B.4.
| Column | Datatype | Description |
|---|---|---|
| ExpenseID | Numeric (Identity) | Unique expense ID |
| FilmID | Numeric | Movie ID |
| ExpenseAmount | Real | Expense amount |
| Description | Text (100 chars) | Expense description |
| Expense Date | Date Time | Expense date |
ExpenseID
FilmID related to primary key in Films table
Read now
Unlock full access