What are the four primary elements of the database environment?

Q: State the different elements of a computer system.

A:

Q: What are the fundamental objectives of all information systems?

A:

Q: What is the objective of a transaction log?

A: Auditing is a gathering of information and evaluation of evidence as to report on the degree of…

Q: What are the five control implications of distributed data processing?

A:

Q: Explain how linkages between relational tables are accomplished.

A: Foreign Key: The primary key of a file is used to identify a record in another file is known as a…

Q: Is a data flow diagram an effective documentation technique for identifying who or what performs a…

A:

Q: Database entities a. may contain zero or many occurrences. b. are represented as verbs in an ER…

A: Database:   Database is the organized collection of associated data elements which is used to have…

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

A:

Q: What are the key features of POS system

A: POS System: It helps in integration of sales monitoring, analytics and reporting, data management of…

Q: What is the purpose of a responsibility center file?

A: Definition: Responsibility center file: The departments of the organization are generally referred…

Q: What is data mining?

A:

Q: What are the three cycles of transaction processing systems?

A:

Q: What is the relationship between a database table and a user view?

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: Explain an example of internal users.

A: Accounting: Accounting is a system, or a process of collecting and organizing economic transactions,…

Q: Name three components of a Transaction Processing System.

A: A Transaction Processing System is a set of information that processes the transaction data in the…

Q: What is a semantic data model?

A:

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

A:

Q: what is an example of data flow diagram, fixed asses system?

A: A data flow diagram (DFD) refers to a graphical representation of a flow of any information or…

Q: What rules govern data collection?

A:

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

A: Data Warehousing:   Data warehousing is a method through which an organization collects and manages…

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: What are the levels of data hierarchy?

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

Q: Give three examples of a transaction processing system.

A:

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

A:

Q: What information is contained in the general ledger master file?

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

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: What do the relational features restrict, project, and join mean?

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

Q: In the flat-file data management environment, users are said to own their data files. What is meant…

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

Q: Explain how the E-R diagrams is used to prepare database tables. Also, include explanation of…

A: ER diagram stands for "Entity Relationship", which can be defined as a type of flowchart that is a…

Q: What are fundamental tasks of data base managment ?

A: “Since you have asked multiple question, we will solve the first question for you. If youwant any…

Q: What is a data dictionary, and what purpose does it serve?

A: Return on investment (ROI):   Return on investment evaluates how efficiently the assets are used in…

Q: Give an application for a partitioned database.

A: Database Management: It refers to the process of managing the databases that are held within a…

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

A: The modern world is completely centered around information. Companies, big and small, generate a lot…

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: What different accounting transaction process needs a data warehouse? Why?

A: Accounting Information system is a set of components used for gathering, making, storing, preparing,…

Q: three major subsystems of the transaction processing system

A: The transaction processing system is one of the three major subsystems of Accounting Information…

Q: Computer-based systems employ four types of files. Name them.

A: In a computer based systems, there are four types of files: Master Files Transaction Files…

Q: What is the role of a Database Administrator?

A: Database:  A database can be defined as a collection of structured data which is stored in digital…

Q: What are the four characteristics of properly designed relational database tables?

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

Q: What is the closed database architecture?

A:

Q: What is the purpose of Transaction Tagging?

A: Tagging and tracking transaction: In tagging and tracking transaction technique, the auditor puts a…

Q: Explain the purpose of an ER diagram in database design.

A:

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…