Explain why the data warehouse needs to be separate from the operational database.

Q: An integrated group of programs that supports the applications and facilitates their access to…

A:

Q: s data independence? why is it important in a comparison of the application and centralised database…

A:

Q: Explain how an IT environment affects the segregation of functions.

A: Segregation of Duties (SoD) is a set of controls and policies intended to ensure accuracy and keep…

Q: Create a system flowchart of the existing system.

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

Q: riefly provide your opinion whether an auditors wishing to assess the adequacy of separation of…

A:

Q: This chapter stressed the importance of data normalization when constructing a relational database.…

A: Data warehousing is a method through which an organization collects and manages the data from the…

Q: Explain how a data warehouse database is fundamentally different from a transaction processing…

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

Q: Discuss the rules for assigning primary keys to database tables.

A:

Q: Distinguish between a database lockout and a deadlock.

A: Definition: Database: The database is a collection of the data that is stored and accessed in…

Q: The database model most likely to be used in the development of a modern (not legacy) system is a.…

A:

Q: The database language that allows you to access or maintain data in a database is

A: DCL , DDL ,TCL and DML are 4 groups of SQL commands  that perform different functions. DML ( Data…

Q: The controls in a computerized system are classified asa. input, processing, and output.b. input,…

A: Definition: Internal control: Internal control is a process which ensures continuous reliability of…

Q: Distinguish between entity relationship diagrams, data flow diagrams, and system flowcharts.

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

Q: Explain why an organization would choose to install a distributed instead of a centralized computer…

A: Choosing Distributed Data Processing: There are one or more mainframe computers in centralized…

Q: iscuss the importance of the role of data administrator. In the flat-fie environment, why is such a…

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

Q: What activities are involved in the batch processing system?

A:

Q: What is the relationship among data, information, and an information system?

A: The meanings for following terms are stated below: Data: It can be described as unprocessed facts…

Q: What are some of the more common uses of data codes in accounting information systems?

A:

Q: What are the four primary elements of the database environment?

A: Definition: Database management: Database management refers to the management of databases held…

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

A:

Q: Which of the following is NOT part of the systems implementation process? a. converting databases b.…

A: Select the correct option from the above.

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: Suggest appropriate data entry and data processing controls to ensure spreadsheet accuracy.

A: Accuracy in data entry can be improved by identifying the source of inaccuracies, adhering to robust…

Q: Why are denormalized tables used in data ware-houses?

A: Data Warehouse:   Data warehouse is also termed as enterprise data warehouse. It can be defined as…

Q: How are the summary views in a data warehouse different from views in an operational database?

A: Data Warehousing:   Data warehousing is a method through which an organization collect and manage…

Q: The functions of a database administrator area. database planning, data input preparation, and…

A: Database Administrator: Database administrator looks after the management of data using application…

Q: what is the difference between internal and external users of information, their needs and demands…

A: Accounting Information System (AIS):   The system which helps to gather, store and process the…

Q: Explain the importance of documentation by the systems programmers.

A: Documentation:   Documentation refers to maintain a set of documents by a technical person in the…

Q: Distinguish between the verification model and the discovery model approaches to data mining.

A: Data Mining:   The data mining is the technique which is used by the management reporting system…

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

A:

Q: Discuss why control procedures over access to the data resource become more crucial under the…

A: Definition: Database Management: Database management refers to the management of databases held…

Q: Discuss the major control implications of batch systems with real-time data input. What compensating…

A: Audit: Audit is the process of verification of the compliance of the financial statements.

Q: What types of tasks become redundant in a distributed data processing system?

A: Distributed data system involves reorganization the central IT function into smaller IT units which…

Q: What does data cleansing mean?

A:

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

A:

Q: 1. Explain the audit control over data management!

A: Audit states examination of the business books or financial statements and it helps in detecting any…

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…

Q: What problems does the data cleansing step attempt to resolve?

A: Accounting information system : AIS is a structure used in business for collecting, storing,…

Q: Discuss the characteristics of a computerized information system that make it different from the…

A: The system which is used to record and store the accounting or financial information is termed the…

Q: Which of the following is NOT a database management task?a. retrievalb. storagec. summarizationd.…

A: Database management is an important tool used for the management of data files. This management…

Q: Discuss the importance of the role of the database administrator. In the flat-file environment, why…

A:

Q: Give an application for a replicated database.

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

Q: Examine the diagram below and determine what essential mechanism is missing. Once you have…

A: