Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Make a logical model for the Expenditure process for this company. state the key attributes (primary + foreign keys) and non-key attributes. make sure to

Make a logical model for the Expenditure process for this company.

state the key attributes (primary + foreign keys) and non-key attributes.

make sure to make a distinction between maintenance/master tables and transaction/event tables

image text in transcribedimage text in transcribed
supplier Request Employee Inventory (Inventory Control) Employee (Supervisor) Order Inventory Employee H (Purchasing inventory Clerk) supplier Receive Receiving Inventory Warehouse Clerk supplier Cashier Cash Disburse Cash HMaintenance Tables: Sales Clerk: Sales Clerk #, Name, Street Address, City, State, Zip, Telephone # Customer: Customer #, Name, Street Address, City, State, Zip, Telephone # Warehouse Clerk: Warehouse Clerk #, Name, Street Address, City, State, Zip, Telephone # Shipping Clerk: Shipping Clerk #, Name, Street Address, City, State, Zip, Telephone # A/R Clerk: A/R Clerk #. Name, Street Address, City, State, Zip, Telephone # Controller: Controller ID #, Name, Street Address, City, State, Zip, Telephone # Cash Account: Cash Account #, Bank Name, Type of Account, Beg Balance, Beg Balance Date Inventory Items: Item #, Description, Sales Price, Standard Cost, BQOH, BQOH Date Events Tables: Order: Order #, [Customer #], [Sales Clerk #], Order Date, Date needed Order-Inventory: [Order #], [Item #], Qty Ordered Picking: Picking #, [Warehouse Clerk #], [Order #], Date Picked Picking-Inventory: [Picking #], [item #], Qty Picked Shipping: Shipping #, [Picking #], [Shipping Clerk], [Customer #], Tracking #, Date Shipped Shipping-Inventory: [Shipping #], [Item #], Qty Shipped Returns: Return #, [Shipping #], [Customer #], [Warehouse Clerk #], Return Date Return-Inventory: [Return #], [Shipping #], [Warehouse Clerk #], Return Date Receive Payment: Receipt #, [Order #], [Customer #], [A/R Clerk #], [Cash Account #], Payment Amount, Payment date Deposit: Deposit #, [Controller ID #], Deposit Date, Amount Deposited

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 Best Practices

Authors: Steven M Bragg

7th Edition

1118404149, 9781118404140

More Books

Students also viewed these Accounting questions

Question

Determine Leading or Lagging Power Factor in Python.

Answered: 1 week ago