Questions from Accounting Information Systems

Q: What is the process of normalization? What levels are there,

What is the process of normalization? What levels are there, and why do database developers seek to normalize data?

Q: Jason Saving is an IT auditor for a large, public accounting

Jason Saving is an IT auditor for a large, public accounting firm. His manager has assigned him to the Consolidated Company audit. The IT auditors must complete several evaluating and testing procedure...

Q: Amazon designed its Echo devices to listen, and respond to,

Amazon designed its Echo devices to listen, and respond to, voice commands. But in December of 2016, police in Arkansas sought the audio recordings of Victor Collins for another reason—to help them so...

Q: What is the hierarchy of data in databases? Provide an example

What is the hierarchy of data in databases? Provide an example for a particular accounting application.

Q: What are primary keys in accounting databases and what purpose(s

What are primary keys in accounting databases and what purpose(s) do they serve?

Q: Name some specific accounting files and a potential primary key for each

Name some specific accounting files and a potential primary key for each one.

Q: Describe each of the following database issues that are relevant to accounting

Describe each of the following database issues that are relevant to accounting systems, and give an example of each: (1) data integrity, (2) transaction accuracy and completeness, (3) concurrency proc...

Q: What is the REA model? How does REA differ from more

What is the REA model? How does REA differ from more traditional accounting views of data collection and storage? Hint: Would a traditional accounting database store data about personnel matters?

Q: Suppose that a data modeler creates a database that includes a Sales

Suppose that a data modeler creates a database that includes a Sales table and a Salesperson table. Would you be likely to need a relationship table to link these two entities? Why or why not?

Q: Identify the different data types available for creating data fields in Microsoft

Identify the different data types available for creating data fields in Microsoft Access. Similarly, identify the different types of numbers (e.g., Long integer) you can use if you define a field as a nu...