Accounting Information Systems

10th Edition
Hall + 1 other
Publisher: Cengage Learning,
ISBN: 9781337619202



Accounting Information Systems

10th Edition
Hall + 1 other
Publisher: Cengage Learning,
ISBN: 9781337619202
Chapter 9, Problem 6MCQ
Textbook Problem

One of the first steps in the creation of a relational database is to

  1. a. perform view integration.
  2. b. normalize the tables.
  3. c. construct the physical user view using SQL
  4. d. create a data model of the entities in the system.
  5. e. identify attributes and add foreign keys.

To determine

Identify the option which correctly explains the first step in relation of creation of a database table.

Explanation of Solution

Relational Database:

The set of database tables prepared to access the data by different methods without making any rearrangement in the database tables is termed as relational database. The SQL (Structured Query Language) statements are used to attain information for the queries from the relational databases.


The first step of creating a relational database is to construct a data model which identifies the related tables with the values and the attributes. Tables define the entities and the attributes define the characteristics of the entities. Therefore, this option is correct.


The fifth and last step in creation of a database table is to perform the integration of the data which is useful for the business for analyzing and taking the decision. The data is integrated into the financial and non-financial form. It is not the first step of creating a database table...

Still sussing out bartleby?

Check out a sample textbook solution.

See a sample solution

The Solution to Your Study Problems

Bartleby provides explanations to thousands of textbook problems written by our experts, many with advanced degrees!

Get Started

Chapter 9 Solutions

Accounting Information Systems
Show all chapter solutions
Ch. 9 - What is an entity?Ch. 9 - Give an application for a replicated database.Ch. 9 - Discuss and give an example of the following types...Ch. 9 - Distinguish between association and cardinality.Ch. 9 - Explain how a separate linking table works in a...Ch. 9 - What are the four characteristics of properly...Ch. 9 - What do the relational features restrict, project,...Ch. 9 - What are the conditions for third normal form...Ch. 9 - Explain how the SELECT and WHERE commands help a...Ch. 9 - What is a data model?Ch. 9 - How can a poorly designed database result...Ch. 9 - What is a user view?Ch. 9 - Does a user view always require multiple tables to...Ch. 9 - What three conditions must valid entities meet?Ch. 9 - Can two different entities have the same defining...Ch. 9 - In the flat-file data management environment,...Ch. 9 - Discuss the potential aggravations you might face...Ch. 9 - Discuss why control procedures over access to the...Ch. 9 - What is the relationship between a database table...Ch. 9 - Explain how linkages between relational tables are...Ch. 9 - Explain the purpose of an ER diagram in database...Ch. 9 - SQL has been said to place power in the hands of...Ch. 9 - Discuss the importance of the role of the database...Ch. 9 - As users determine new computer application needs,...Ch. 9 - Why is a separate link table required when an M:M...Ch. 9 - As an accountant, why would you need to be...Ch. 9 - How does a database lockout contribute to...Ch. 9 - How does concurrency control contribute to...Ch. 9 - In a relational database environment, certain...Ch. 9 - Explain how to link tables in a 1:1 cardinality....Ch. 9 - Discuss the accounting implications of the update,...Ch. 9 - Give three examples that illustrate how...Ch. 9 - Discuss the key factors to consider in determining...Ch. 9 - Distinguish between a database lockout and a...Ch. 9 - Replicated databases create considerable data...Ch. 9 - Of the following, select the attribute that would...Ch. 9 - The advantages to using a partitioned database...Ch. 9 - A partial dependency a. is the result of...Ch. 9 - Repeating group data a. cannot exist in tables...Ch. 9 - What term describes the following data items: part...Ch. 9 - One of the first steps in the creation of a...Ch. 9 - Entities in a data model a. may contain zero or...Ch. 9 - Which of the following is least likely to be an...Ch. 9 - Partitioned databases are most effective when a....Ch. 9 - Which of the following is true about a transitive...Ch. 9 - The installation of a database management system...Ch. 9 - Which of the following describe best the functions...Ch. 9 - Database currency is achieved by a. implementing...Ch. 9 - Which of the following is true? a. Each view...Ch. 9 - Which of the following is true? a. Linking I:M...Ch. 9 - Which of the following is true? a. User views...Ch. 9 - Which of the following statements is not true? a....Ch. 9 - The data attributes that a particular user has...Ch. 9 - The Mega Supply Corporation has three divisions:...Ch. 9 - DBMS VERSUS FLAT-FILE PROCESSING Werner...Ch. 9 - Lesters Rentals is located in Cincinnati, Ohio....Ch. 9 - Using the view for a veterinarian practice...Ch. 9 - How is a lockout different from a deadlock? Give...Ch. 9 - Premium Garden Products (PGP) supplies gardening...Ch. 9 - DISTRIBUTED DATABASESREAD ONLY The XYZ Company is...Ch. 9 - DISTRIBUTED DATABASESTRANSACTION PROCESSING The...Ch. 9 - A book checkout report for a library is shown in...Ch. 9 - A college bookstore maintains all of its records...Ch. 9 - Prepare the base tables, in third normal form,...Ch. 9 - Prepare the base tables, in third normal form,...Ch. 9 - Prepare the 3NF base tables needed to produce the...Ch. 9 - Acme Plywood Company uses the purchase order shown...Ch. 9 - Solve this problem per the text in the diagram for...Ch. 9 - The diagram labeled problem 16 presents a partial...Ch. 9 - Refer to the entity relationship diagram in...Ch. 9 - Prepare an entity relationship diagram for the...Ch. 9 - Employees at the Harvest Equipment Company record...Ch. 9 - DATA MODELINGFIXED ASSET Procedures Classic...Ch. 9 - DATA MODELINGGENERAL LEDGER UPDATE Required...Ch. 9 - Given the following business rules, construct an...

Additional Business Textbook Solutions

Find more solutions based on key concepts
Show solutions add
What factors affects the choice of sales promotion used?

Foundations of Business (MindTap Course List)

What information does the statement of cash flows help users assess?

Intermediate Accounting: Reporting And Analysis

All budgets depend on the sales budget. Is this true? Explain.

Managerial Accounting: The Cornerstone of Business Decision-Making

Differentiate between dealer markets and stock markets that have a physical location.

Fundamentals of Financial Management, Concise Edition (with Thomson ONE - Business School Edition, 1 term (6 months) Printed Access Card) (MindTap Course List)