Business Finance Homework Help
UNLV Accounting Inventory Tables Worksheet
Complete problems 4.2 (page 107) and 4.8 (page 110).
When completing 4.8 you are welcome to create the tables in a database program (such as Microsoft Access) but it is not required to do so. You are welcome to simply draw charts in Word or Excel.
For example, the first two rows of the Sample Inventory Table for S&S (Table 4-2 on Page 90 of the text) would be shown like this:
Item Number (PK)DescriptionColorVendor NumberQuantity on HandPrice1036
RefrigeratorWhite100231211991038 RefrigeratorAlmond1002371299
Remember to identify the primary key (PK) in each table as well as the foreign key (FK) that links to other tables where applicable.