Accounting Information Systems
11th Edition
ISBN: 9781337552127
Author: Ulric J. Gelinas, Richard B. Dull, Patrick Wheeler, Mary Callahan Hill
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Question
Chapter 6, Problem 5DQ
Summary Introduction
To explain: The main steps in designing a database.
Introduction:
Relational database:
It is a collection of multiple data sets constituted by rows, columns, and tables. It aids in developing a well-established relationship between different database tables. Information is shared between these tables for efficient use.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Explain how the E-R diagrams is used to prepare database tables. Also, include explanation of cardinalities.
What is a data flow diagram? What are the different levels from most general to most detailed? Draw the common symbols used.
Explain why the data warehouse needs to be separate from the operational database.
Chapter 6 Solutions
Accounting Information Systems
Ch. 6 - What is business intelligence (BI)?Ch. 6 - Prob. 2RQCh. 6 - Prob. 3RQCh. 6 - Prob. 4RQCh. 6 - What is a relationship?Ch. 6 - Prob. 6RQCh. 6 - Prob. 7RQCh. 6 - Prob. 8RQCh. 6 - How can an REA model help an organization improve...Ch. 6 - Prob. 10RQ
Ch. 6 - Prob. 11RQCh. 6 - Prob. 12RQCh. 6 - What is a foreign key? How are foreign keys...Ch. 6 - Prob. 14RQCh. 6 - Prob. 15RQCh. 6 - Prob. 1DQCh. 6 - What is a model? How is modeling a database or...Ch. 6 - Prob. 3DQCh. 6 - Prob. 4DQCh. 6 - Prob. 5DQCh. 6 - Prob. 6DQCh. 6 - Although todays enterprise systems incorporate...Ch. 6 - Prob. 8DQCh. 6 - Prob. 1SPCh. 6 - Prob. 2SPCh. 6 - Examine Figure 6.18, which contains the REA model...Ch. 6 - Prob. 6SPCh. 6 - Prob. 7SPCh. 6 - What SQL command(s) would you use to add the date...Ch. 6 - Prob. 2P
Knowledge Booster
Similar questions
- Is a data flow diagram an effective documentation technique for identifying who or what performs a particular task? Explain.arrow_forwardWhat are the four basic backup and recovery features necessary in a database management system? Briefly explain each.arrow_forwardThe data attributes that a particular user has permission to access are defined by the a. operating system view. b. systems design view. c. database schema. d. user view. e. application program.arrow_forward
- A Data Flow Diagram (DFD) is composed of which of the following elements?Select one:a. Data Flowsb. All of the abovec. Transformation Processesd. Data sources and destinationsarrow_forwardOutline the traditional problems associated with the flatfile model that are resolved by the database model.arrow_forwardThe functions of a database administrator area. database planning, data input preparation, and database design.b. data input preparation, database design, and database operation.c. database design, database operation, and equipment operations.d. database design, database implementation, and database planning.e. database operations, database maintenance, and data input preparation.arrow_forward
- What problems can the following excel tools solve in acccounting? Pivot tables: Conditional formatting: Data Analysis and Formulas: Data Visualization (Charts & Graphs):arrow_forwardOne of the first steps in the creation of a relational database is toa. integrate accounting and nonfinancial data.b. plan for increased secondary storage capacity.c. order data-mining software that will facilitate data retrieval.d. create a data model of the key entities in the system.e. construct the physical user view using SQL.arrow_forwardSuggest appropriate data entry and data processing controls to ensure spreadsheet accuracy.arrow_forward
- A documentation tool that depicts the physical flow of information relating to a particular transaction through an organization is aa. system flowchart.b. program flowchart.c. decision table.d. work distribution analysis.e. systems survey.arrow_forwardWhich of the following general data flows is shown on a computerized system flowchart? O Process-output Output-process O Output-process-input O Input-process-outputarrow_forwardData flow diagrams employ four different symbols. What are these symbols, and what does each symbol represent?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,
Auditing: A Risk Based-Approach (MindTap Course L...AccountingISBN:9781337619455Author:Karla M Johnstone, Audrey A. Gramling, Larry E. RittenbergPublisher:Cengage Learning
Accounting Information Systems
Accounting
ISBN:9781337619202
Author:Hall, James A.
Publisher:Cengage Learning,
Auditing: A Risk Based-Approach (MindTap Course L...
Accounting
ISBN:9781337619455
Author:Karla M Johnstone, Audrey A. Gramling, Larry E. Rittenberg
Publisher:Cengage Learning