Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Ians place sells pet supplies to dog and cat owners. To sell its products, the marketing the department requires sales personnel to call on the

Ians place sells pet supplies to dog and cat owners. To sell its products, the marketing the department requires sales personnel to call on the pet store retailers within their assigned geographic territories. Salespeople have an application on their mobile phones that allows them to record sales orders and send these sales orders directly to the company network for updating the companys sales order file. Each day, warehouse personnel review the current sales orders in its file, and where possible, pick the goods and ready them for shipment. When the shipping department completes a shipment, it also notifies the billing department, which then prepares an invoice for the customer. Payment terms vary by customer, but most are net 30. when the billing department receives a payment, the billing clerk credits the customers account and records the cash received.

Requirements: identify the database tables, and define attributes for each table. E-R diagram is already provided. image text in transcribedimage text in transcribed

Sales personnel Sales order + Inventory Customer + Ship goods Shipping clerk Cash HI Cash collections # + Billing clerk Table Name Primary Key Foreign Key Other Attributes Inventory Item No. Customer Customer No. Sales Personnel Sales Personnel No. Shipping Clerk Ship Clerk No. Billing Clerk Bill Clerk No. Cash Sales Order Ship Goods Cash No. Order No. Ship No. Cash Collection Collection No. Ship Goods Inventory Order Ship No., Order No., Inventory No. Shipment Cash Receipt Ship No., Cash Receipt No

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

Accounting And Business Ethics An Introduction

Authors: Ken McPhail, Diane Walters

1st Edition

0674018788, 9780415362368

More Books

Students also viewed these Accounting questions

Question

Review the findings of humanistic psychotherapy outcome research.

Answered: 1 week ago