Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Using the REA approach to developing a database for an accounting system, you have identified one event, or activity, that needs to be included

 

Using the REA approach to developing a database for an accounting system, you have identified one event, or activity, that needs to be included in the database. The event is a purchase from a vendor. The organization makes over-the-counter purchases in which the purchasing agent makes a purchase and immediately receives the goods purchased. All purchases are on account, and the company uses a voucher number to uniquely identify all purchases. Required: a. Identify any resources and agents that are related to the purchase event. Document the event and any resources and agents with an E-R diagram. b. Identify the relationship among the events, resources, and agents. Add these relationships to your E-R diagram. Indicate on your E-R diagram the type of each relationship that is, 1:1,1:*, *:1, or *.*. c. Identify and list the attributes that are related to the resources, events, agents, and relationships. d. Create the appropriate database tables by referring to the E-R diagram.

Step by Step Solution

3.37 Rating (181 Votes )

There are 3 Steps involved in it

Step: 1

a... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Future of Business

Authors: Norm Althouse, Laura Allan, Christopher Hartt

5th edition

176509631, 978-0176509637, 017657025X, 978-0176570255

More Books

Students also viewed these Accounting questions

Question

Review the findings of humanistic psychotherapy outcome research.

Answered: 1 week ago

Question

How are business products classified?

Answered: 1 week ago

Question

What is the most common problem to avoid during interviewing?

Answered: 1 week ago