Questions from Accounting Information Systems

Q: What is a data dictionary, what does it contain, and

What is a data dictionary, what does it contain, and how is it used?

Q: An audit trail enables a person to trace a source document to

An audit trail enables a person to trace a source document to its ultimate effect on the financial statements or work back from amounts in the financial statements to source documents. Describe in det...

Q: Some restaurants use customer checks with prenumbered sequence codes. Each food

Some restaurants use customer checks with prenumbered sequence codes. Each food server uses these checks to write up customer orders. Food servers are told not to destroy any customer checks; if a m...

Q: Compare and contrast the file-oriented approach and the database approach

Compare and contrast the file-oriented approach and the database approach. Explain the main advantages of database systems.

Q: Contrast the logical and the physical views of data and discuss why

Contrast the logical and the physical views of data and discuss why separate views are necessary in database applications. Describe which perspective is most useful for each of the following employees...

Q: The relational data model represents data as being stored in tables.

The relational data model represents data as being stored in tables. Spreadsheets are another tool that accountants use to employ a tabular representation of data. What are some similarities and diffe...

Q: As in all areas of IT, DBMSs are constantly changing and

As in all areas of IT, DBMSs are constantly changing and improving. Research how businesses are using DBMSs, and write a report of your findings. Address the following issues: 1. Which popular DBMS pr...

Q: You want to extend the schema shown in Table 4-16

You want to extend the schema shown in Table 4-16 to include information about customer payments. Some customers make installment payments on each invoice. Others write a check to pay for several diff...

Q: Create relational tables that solve the update, insert, and delete

Create relational tables that solve the update, insert, and delete anomalies in Table 4-17.

Q: Create relational tables that solve the update, insert, and delete

Create relational tables that solve the update, insert, and delete anomalies in Table 4-18.