Question

You have been hired to evaluate an accounting information systemfor fixed asset inventory tracking to determine if proper controlsand security are present for financial reporting. You notice thecompany has a number of items in inventory but there does not seemto be any pattern to the data they collect. For example, some itemshave a location or department where the item is located others donot, some items have a tracking tag, others do not, etc. How wouldyou set up a fixed asset database for this company to ensure propercontrols over the data, security of the items, and the accuracy ofthe data for financial reporting?

Provide an example of your database(s) design andwhy you selected that design.