Refer to Figure and Table. How would you determine the amount of cash that Fred’s Train Sh...

ATTRIBUTES

TABLES

PRIMARY KEY

FOREIGN KEYS

OTHER ATTRIBUTES

Order Inventory

Purchase order number

Supplier number, employee number

Date, time, reason

Receive Inventory

Receiving report

Supplier number, employee number, purchase order number, check number

Date, time, remarks, vendor invoice number

Disburse Cash

Check number

Supplier number, employee umber (payee), employee number (signer), account number

Amount, description, date

Take Customer

Sales order number

Customer number, employee number

Date, time, special remarks

Sales

Invoice number

Customer number, employee number, sales order number

Date, time, invoice sent (Y/N)

Receive Cash

Remittance number

Customer number, employee number, account number

Date, time, method of payment

Time Worked

Timecard number

Employee number, supervisor number, paycheck number

Date, time in, time out

Inventory

Product number

Description, list price, standard cost, beginning quantity-on-hand, beginning quantity-available, reorder quantity, reorder point

Cash

Account number

Beginning-balance, type of account

Employees

Employee number

Name, date hired, date of birth, pay rate, job title

Customers

Customer number

Name, address,a beginning account balance, credit limit

Suppliers

Supplier number

Name, address,a beginning account balance, performance rating

Order Inventory—Inventory

Purchase order number, product number

Quantity ordered, actual unit cost

Receive Inventory—Inventory

Receiving report number, product number

Quantity received, condition

Take Customer Order—Inventory

Sales order number, product number

Quantity ordered

Sales—Inventory

Invoice number, product number

Quantity sold, actual sale price

Sales—Receive Cash

Invoice number, remittance number

Amount applied to invoice