Explanation Data Model: Data model refers to a model which helps in presenting the data in a visual form for analyzing the situation and to adopt a new system in the organization. It explains the data and the regulations are used in the organization for the business. The data model for the purchasing system of the organization is given below: The un-normalized data model for the system: Fig (1) In Fig (1), there is an un-normalized data model of the purchasing system of the stores. Normalized data model with primary keys, foreign keys, and the attributes: Fig (2) In fig (2) there is a normalized data model of the purchasing system of the store. For the purchases of the goods for the store, purchase manager of every location is responsible for the selection of a supplier for the goods. The process that every store follows for the purchase of the goods is: It starts with the purchasing function in which the sales representatives of the suppliers observe the need for stock and the sales representative reviews the obsolescence reports which is prepared by the purchase manager...

Accounting Information Systems 9th Edition

9th Edition

ISBN: 9781305756700

Author: Hall

Publisher: CENGAGE C

See similar textbooks

Videos

Question

Chapter 9, Problem 20P

To determine

Prepare a data model for the purchasing system.

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Chapter 9, Problem 19P

Chapter 9, Problem 21P

Students have asked these similar questions

None

Please give me answer general accounting question

What is the average balance sheet amount in account receivables? Give me answer

Chapter 9 Solutions

Accounting Information Systems 9th Edition

Ch. 9 - Prob. 1RQ Ch. 9 - Prob. 2RQ Ch. 9 - Prob. 3RQ Ch. 9 - Prob. 4RQ Ch. 9 - Prob. 5RQ Ch. 9 - Prob. 6RQ Ch. 9 - Prob. 7RQ Ch. 9 - Prob. 8RQ Ch. 9 - Prob. 9RQ Ch. 9 - Prob. 10RQ

Ch. 9 - Prob. 11RQ Ch. 9 - Prob. 12RQ Ch. 9 - Prob. 13RQ Ch. 9 - Prob. 14RQ Ch. 9 - Prob. 15RQ Ch. 9 - Prob. 16RQ Ch. 9 - Prob. 17RQ Ch. 9 - What are the conditions for third normal form...Ch. 9 - Prob. 19RQ Ch. 9 - Prob. 20RQ Ch. 9 - Prob. 21RQ Ch. 9 - What is a user view?Ch. 9 - Prob. 23RQ Ch. 9 - Prob. 24RQ Ch. 9 - Prob. 25RQ Ch. 9 - Prob. 1DQ Ch. 9 - Prob. 2DQ Ch. 9 - Prob. 3DQ Ch. 9 - Prob. 4DQ Ch. 9 - Prob. 5DQ Ch. 9 - Prob. 6DQ Ch. 9 - Prob. 7DQ Ch. 9 - Prob. 8DQ Ch. 9 - Prob. 9DQ Ch. 9 - Prob. 10DQ Ch. 9 - Prob. 11DQ Ch. 9 - Prob. 12DQ Ch. 9 - Prob. 13DQ Ch. 9 - Prob. 14DQ Ch. 9 - Prob. 15DQ Ch. 9 - Discuss the accounting implications of the update,...Ch. 9 - Prob. 17DQ Ch. 9 - Prob. 18DQ Ch. 9 - Prob. 19DQ Ch. 9 - Prob. 20DQ Ch. 9 - Prob. 1MCQ Ch. 9 - Prob. 2MCQ Ch. 9 - Prob. 3MCQ Ch. 9 - Prob. 4MCQ Ch. 9 - Prob. 5MCQ Ch. 9 - Prob. 6MCQ Ch. 9 - Prob. 7MCQ Ch. 9 - Prob. 8MCQ Ch. 9 - Prob. 9MCQ Ch. 9 - Prob. 10MCQ Ch. 9 - Prob. 11MCQ Ch. 9 - Prob. 12MCQ Ch. 9 - Prob. 13MCQ Ch. 9 - Prob. 14MCQ Ch. 9 - Prob. 15MCQ Ch. 9 - Prob. 16MCQ Ch. 9 - Prob. 17MCQ Ch. 9 - Prob. 18MCQ Ch. 9 - The Mega Supply Corporation has three divisions:...Ch. 9 - Prob. 2P Ch. 9 - Lesters Rentals is located in Cincinnati, Ohio....Ch. 9 - Prob. 4P Ch. 9 - Prob. 5P Ch. 9 - Prob. 6P Ch. 9 - Prob. 7P Ch. 9 - Prob. 8P Ch. 9 - Prob. 9P Ch. 9 - Prob. 10P Ch. 9 - Prob. 11P Ch. 9 - Prob. 12P Ch. 9 - Prepare the 3NF base tables needed to produce the...Ch. 9 - Prob. 14P Ch. 9 - Prob. 15P Ch. 9 - Prob. 16P Ch. 9 - Prob. 17P Ch. 9 - Prob. 18P Ch. 9 - Prob. 19P Ch. 9 - Prob. 20P Ch. 9 - Prob. 21P Ch. 9 - Prob. 22P Ch. 9 - Prob. 23P Ch. 9 - Prob. 24P Ch. 9 - Prob. 25P

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.

Similar questions

SEE MORE QUESTIONS

Recommended textbooks for you

Accounting Information Systems
Accounting
ISBN:9781337619202
Author:Hall, James A.
Publisher:Cengage Learning,
College Accounting, Chapters 1-27
Accounting
ISBN:9781337794756
Author:HEINTZ, James A.
Publisher:Cengage Learning,
Auditing: A Risk Based-Approach to Conducting a Q...
Accounting
ISBN:9781305080577
Author:Karla M Johnstone, Audrey A. Gramling, Larry E. Rittenberg
Publisher:South-Western College Pub
Principles of Accounting Volume 1
Accounting
ISBN:9781947172685
Author:OpenStax
Publisher:OpenStax College
Principles of Accounting Volume 2
Accounting
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax College
Auditing: A Risk Based-Approach (MindTap Course L...
Accounting
ISBN:9781337619455
Author:Karla M Johnstone, Audrey A. Gramling, Larry E. Rittenberg
Publisher:Cengage Learning