Why are denormalized tables used in data ware-houses?

Q: What type of internal control would recalculating the totals on a computer report be?

A: Step 1:   The rules and procedures implemented by a company to ensure the integrity of the…

Q: what factor influences the decisions to employ real time data collection with batch updating rather…

A: Transaction process system:   Transaction process system can be defined as a system designed to…

Q: How can data analysis be used to identify stakeholders?

A: Stakeholder analysis involves the study of identifying, collecting, and analyzing data on different…

Q: what are the process of system flowchart?

A: System flowchart is the diagrammatically representation of how data (or information) flows from one…

Q: What are the primary objectives of a batch control?

A:

Q: What flat-file data management problems are solved as a result of using the database concep

A: Database Management:   Database management refers to management of databases held within an…

Q: What document is used to determine which tables of data are necessary?

A:

Q: Why should test data be saved after it has been used?

A: Test Data: The data which prepared before the conduction of a test to evaluate its results is known…

Q: What factors influences the decision to employ real time data collection with batch updating rather…

A: Batch Processing through Real Time Data collection system:Real time processing process the…

Q: Descriptive statistics consists of methods for organizing, displaying, and describing data by using…

A: A data set in original form usually very large, consequently such data is not very helpful in…

Q: What are the three general problems associated with data redundancy?

A:

Q: What rules govern data collection?

A:

Q: What is an access control list?

A: Access Control List  The list which restricts the access of the objects attached in an information…

Q: What are the levels of data hierarchy?

A: Accounting Information System:   This refers to a system that is adopted by an organization to…

Q: Identifying the condition of the data is part of which task?   A. Performing a data audit B.…

A: Identifying the data means you are in a search of some information that is useful for you.

Q: What is a data model?

A: Data model is presentation of data in a logical manner; so that, data can be read and processed by…

Q: Which of the following is a control that can be used to ensure that all of the components of an…

A: The procedures for rejection inputs is a  control that can be used by the auditor to ensure that all…

Q: What very important precautions must be taken during the data conversion procedures?

A:

Q: What is a data flow diagram? What are the different levels from most general to most detailed? Draw…

A:

Q: What exposures do data consolidation in a CBIS environment pose?

A:

Q: What are the categories of processing controls?

A: Internal Control:   It is a process of assuring the effectiveness and efficiency of the objectives…

Q: What factor influences the decision to employ real-time data collection with batch updating rather…

A: Definition: Transaction process system: The transaction process system can be defined as a system…

Q: Interpretation of the data:

A: We are provided with the monthly sales report and in order to better interpret the data we will have…

Q: Ratios are an input into which step in the fi nancial statement analysis framework? A . Process…

A: The analysis of financial statements is the method of review for the decision-making of a firm's…

Q: How are run charts useful in process control?

A: A run chart is a graph of data that is plotted over time. For a particular process if you collect…

Q: Briefly describe record counts, batch totals, and hash totals. What types of errors in input…

A: Input controls: It is created to provide reasonable guarantee of received data for processing by the…

Q: Reviewing database authority tables is a(n) a. access control. b. organizational structure control.…

A: An operating device must have strict security features to guard and hold device integrity. The…

Q: Is access control of greater concern in the flat-file or database file environment?

A: Access Control: Access control can be defined as a process which is incorporated into the IT…

Q: How does the Genral Ledger work?

A: General ledger is the account prepared by the company for each transactions made by the company. It…

Q: What role does the general ledger department play in the conversion cycle?

A: Conversion Cycle: A set of all processes that are used to collect inputs and convert them into final…

Q: How can forwardrates be used for hedging purposes?

A: SOLUTION:- Risk management is the main stimulus for forward contracts. Forward contract is a…

Q: What is the purpose of the general ledger history file?

A: General Ledger:   The financial information required for the preparation of financial report; of…

Q: Why might an auditor use a program flowchart?

A: Flowchart:   Flowchart is representation of procedures concerned with the transactions in the…

Q: Explain the relationship between the three levels of the data definition language. As a user, which…

A:

Q: As an accountant, why would you need to be familiar with data normalization techniques?

A:

Q: What is a data warehouse?

A: Definition: Database: A database can be defined as the collection of data in an organized manner…

Q: What is changed data capture?

A: Definition: Database: A database can be defined as the collection of data in an organized manner…

Q: What are the advantages of real-time data processing?

A:

Q: What is a central repository in a CASE system?

A: Definition: Computer-aided software engineering (CASE) tool: Computer-aided software engineering is…

Q: Briefly provide your opinion whether an auditor wishing to assess the adequacy of separation of…

A:

Q: What information is provided by a record layout diagram?

A:

Q: What is a data dictionary?

A: Dictionary is the storage of words of a language where the equivalent meanings of the words can be…

Q: What is the role of the data Librarian?

A: Auditing means the inspection of financial accounts of the company to determine if the records are…

Q: at data:

A: Equivalent number is the number of units that is actually being used in the manufacturing of…

Q: “If we document a system with a systems flowchart and data flowdiagrams, we have overdocumented the…

A: AIS termed as Accounting information system which is defined as the structure that the companies…