Data Analytics For Accounting
19th Edition
ISBN: 9781260375183
Author: RICHARDSON
Publisher: MCG
expand_more
expand_more
format_list_bulleted
Question
Chapter 2, Problem 4DQ
To determine
Explain how the primary key/foreign key relationship structure helps in enforcing a business rule that indicates that a company should not process any purchase orders from suppliers who does not exist in the database.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Which of the following is a risk to the financial statement of a company when it places a purchase order with a supplier?
The advantages of PDF files are:
A. that they can be securely locked so that the figures cannot be changed.B. that they can be easily manipulated and changed by users.C. the software to produce them is very cheap.D. none of the options are correct.
2. What is information overload?
A. The situation where a computer has more information than is needed or is able to be processed in a meaningful way when a computer program is executed.B. The situation where an individual has more information than is needed or is able to be processed in a meaningful way when working through a decision.C. The situation where a computer has more information than is needed or is able to be processed when data storage is taking place.D. The situation where the amount of information exceeds the storage capacity of the brain of a human being.
3. When all data are stored in a central place,…
Distinguish the revenue cycle activities and operations of a conventional "brick and mortar" company from those of an internet business. Avoid using the same distinctions between data flow and system flowcharts in your answer.
Which one of the following is not correct in relation to database?Select one:a. Helps in creating a business power point presentationsb. A database is usually controlled by a database management system (DBMS)c. A structured set of data held in a computer, especially one that is accessible in various ways.d. Most databases use structured query language (SQL) for writing and querying data.
Chapter 2 Solutions
Data Analytics For Accounting
Ch. 2 - Prob. 1MCQCh. 2 - Prob. 2MCQCh. 2 - Prob. 3MCQCh. 2 - Prob. 4MCQCh. 2 - Prob. 5MCQCh. 2 - Prob. 6MCQCh. 2 - Prob. 7MCQCh. 2 - Prob. 8MCQCh. 2 - Prob. 9MCQCh. 2 - Prob. 10MCQ
Ch. 2 - Prob. 1DQCh. 2 - Prob. 2DQCh. 2 - Prob. 3DQCh. 2 - Prob. 4DQCh. 2 - Prob. 5DQCh. 2 - Prob. 6DQCh. 2 - Prob. 7DQCh. 2 - Prob. 8DQCh. 2 - Prob. 9DQCh. 2 - Prob. 10DQCh. 2 - Prob. 1PCh. 2 - Prob. 2PCh. 2 - Prob. 3PCh. 2 - Which attributes from the College Scorecard data...Ch. 2 - Prob. 5PCh. 2 - Which attributes from the College Scorecard data...Ch. 2 - Use the College Scorecard data to determine if...Ch. 2 - Prob. 8PCh. 2 - Prob. 9P
Knowledge Booster
Similar questions
- Which preventive, detective, and/or corrective controls would best mitigate the following threat, and why? (f) A company purchased the leading “off-the-shelf” e-commerce software for linking its electronic storefront to its inventory database. A customer discovered a way to directly access the database by entering appropriate SQL code.arrow_forwardDiscuss the importance of the role of the database administrator. In the flat-file environment, why is such a role not necessary? What tasks does the DBA perform?arrow_forwardWhich of the following is false about accounting information systems? A. They provide reports that people analyze. B. They prevent errors and stop employees from stealing inventory. C. They are designed to gather data about the companys transactions. D. They consist of processes that involve input of data from source documents, processing, output, and storage.arrow_forward
- Discuss why control procedures over access to the data resource become more crucial under the database approach than in the flat-file environment. What role does the DBMS play in helping to control the database environment?arrow_forwardSuppose your company has built a database application that runs on a centralized database, but even with a high-end computer and appropriate indices created on the data, the system is not able to handle the transaction load, leading to slow processing of queries. What would be some of your options to allow the application to handle the transaction load?arrow_forwardWhat types of unique control problems are created by the use of PC accounting systems?arrow_forward
- Which of the following statements is not correct? a.The database approach uses one common database to promote the concept of single user view. b.Database systems resolve task data dependency. c.The flat-file model encourages data redundancy. d.A primary goal of databasesystems is to minimize data redundancy. e.Database systems provide increased accessibility to data and data integration.arrow_forwardWhich statement is NOT true? a. Drill-down capability is an OLAP feature of data mining tools available to the user. b. The data warehouse should be separate from operational systems. c. Denormalization of data involves dividing the data into very small tables that support detailed analysis. d. Some decisions supported by a data warehouse are not fundamentally different from those that are supported by traditional databases. e. Data cleansing involves transforming data into standard business terms with standard data values.arrow_forwardTwo geographically distributed companies have several facilities around the country. The database users in company “A” need rapid access to common data for read-only purposes. Company “B” users need rapid access to data for transaction processing purposes. Their sites are autonomous; they do not share the same customers, products, or suppliers Under these circumstances: Which distributed database method is best for company “A”. Explain your reasoning. Which distributed database method is best for company “B”. Explain your reasoning.arrow_forward
- The computer processing portion of a sales order system is represented by the flowchart. Answer the following questions.a. What type of data processing system is this? Explain, and be specific.b. The auditor suggests that this system can be greatly simplified by changing to direct access files. Explain the major operational changes that would occur in the system if this were done.c. The auditor warns of control implications from this change that must be considered. Explain the nature of the control implications.d. Sketch a flowchart (the computerized portion only) of the proposed new system. Use correct symbols and label the diagram.arrow_forwardWhich of the following is a characteristic of a relational database system?a. All data within the system are shared by all users to facilitate integration.b. Database processing follows explicit links that are contained within the records.c. User views limit access to the database.d. Transaction processing and data warehousing systems share a common database.arrow_forwardSome people believe database technology may eliminate the need for double-entry accounting. This creates three possibilities: (1) the double-entry model will be abandoned; (2) the double-entry model will not be used directly, but an external-level schema based on the double-entry model will be defined for accountants’ use; or (3) the double-entry model will be retained in database systems. Which alternative do you think is most likely to occur? Why?arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
Principles of Accounting Volume 1AccountingISBN:9781947172685Author:OpenStaxPublisher:OpenStax College
Pkg Acc Infor Systems MS VISIO CDFinanceISBN:9781133935940Author:Ulric J. GelinasPublisher:CENGAGE L
Accounting Information Systems
Accounting
ISBN:9781337619202
Author:Hall, James A.
Publisher:Cengage Learning,
Principles of Accounting Volume 1
Accounting
ISBN:9781947172685
Author:OpenStax
Publisher:OpenStax College
Pkg Acc Infor Systems MS VISIO CD
Finance
ISBN:9781133935940
Author:Ulric J. Gelinas
Publisher:CENGAGE L