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.