BuyFindarrow_forward

Accounting Information Systems

11th Edition
Ulric J. Gelinas + 3 others
ISBN: 9781337552127

Solutions

Chapter
Section
BuyFindarrow_forward

Accounting Information Systems

11th Edition
Ulric J. Gelinas + 3 others
ISBN: 9781337552127
Textbook Problem

Examine the REA model for Hera Industrial Supply that appears in Figure 6.18. For each of the six entities in the model, list the attributes that a database designer should include in each table. Identify primary key attributes with (PK) and composite primary key attributes with (CPK). State any assumptions you needed to make, and be prepared to defend the rationale for the attributes you have chosen.

Summary Introduction

To list: The attributes that a database designer should include in each table and identify primary key attributes and composite key attributes with justifications.

Explanation

Resources-Events-Agents (REA) model:

  • This model tells how the accounting system can be re-engineered for the computer age. This model helps in eliminating many accounting objects that are not that necessary in the computer age.

Primary key: It is the unique identifier present within the table.

Foreign key: It is nothing but a primary key that serves as a bridge between unrelated tables in order to tie them, or link them, together

Composite key: It is nothing but a primary key that is created by combining two or more columns in a table.

Justification:

  • The attributes that should be included in Employees (Salespersons) table:
    • Employee name (Primary key)
    • Employee address
    • Customers assigned to salesperson
  • The attributes that should be included in Customers table:
    • Customer code (primary key)
    • Customer name
    • Customer address
    • Credit limit
    • Sales year-to-date
    • Sales person assigned to customer
  • The attributes that should be included in sales orders table:
    • Sales order number (primary key)
    • Customer code

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

Additional Business Solutions

Find more solutions based on key concepts

Show solutions add

What is a loan amortization schedule, and what are some ways these schedules are used?

Fundamentals of Financial Management, Concise Edition (MindTap Course List)

Why do economists oppose policies that restrict trade among nations?

Brief Principles of Macroeconomics (MindTap Course List)

Which one is best?

Foundations of Business (MindTap Course List)

Explain cause-related marketing

MKTG 12:STUDENT ED.-TEXT

PORTFOLIO BETA Suppose you held a diversified portfolio consisting of a 7,500 investment in each of 20 differen...

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

All sales, for cash or on credit, can be recorded in the general journal.

College Accounting, Chapters 1-27 (New in Accounting from Heintz and Parry)