Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Animal Company Inc. is a business located in Harrison. It sells office furniture and supplies to customers. At present, Animal Company Inc. processes its sales

image text in transcribed

Animal Company Inc. is a business located in Harrison. It sells office furniture and supplies to customers. At present, Animal Company Inc. processes its sales manually and asks you to develop a database to help better process sales data. You have conducted several interviews with employees. The following is a summary of your discussions. When a customer places an order (e.g., desks and chairs), the order is recorded by one of managers of Animal Company Inc. The order is then shipped within one week from one of employees in the warehouse department to the customer. Also, the employee may include more than one order in one shipment if the orders are made by the same customer. Because Animal Company Inc. values fast service, the employee may make multiple shipments to fulfill one order if the production team gets behind in manufacturing the requested items. Another manager of Animal Company Inc. daily reviews the shipping document completed by the employee before each shipment and bills customers weekly for all orders shipped that week. Customers are given 30 days to pay and required to pay all invoices in full. In addition, an employee in the accounting deportment may accept one check to cover two or more orders. Animal Company Inc. has both a checking account and a savings account at MA State Bank, and the checking account is used for cash receipt purposes. Based on the above narrative description, create a REA diagram

Step by Step Solution

There are 3 Steps involved in it

Step: 1

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

Step: 3

blur-text-image

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

Microsoft Visual Basic 2005 For Windows Mobile Web Office And Database Applications Comprehensive

Authors: Gary B. Shelly, Thomas J. Cashman, Corinne Hoisington

1st Edition

0619254823, 978-0619254827

More Books

Students also viewed these Databases questions