You have been hired to evaluate an accounting information systemfor fixed asset inventory tracking...

70.2K

Verified Solution

Question

Accounting

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.

Answer & Explanation Solved by verified expert

4.3 Ratings (803 Votes)

In selecting a fixed asset databse design the following are what we should be looking in selecting a particular design Selected the database design based on the size of our project There are many aspects that come with choosing a database design starting from basic tracking units to linking See Answer

Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:

Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!

Become a Member

Transcribed Image Text

In: AccountingYou have been hired to evaluate an accounting information systemfor fixed asset inventory tracking to...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.