Data Management AND System Analysis and Project Management

A company keeps the following database table to track account balance of customers:

Customer(Customer#, CustomerName, CustomerBalance)

The company updates the table using the following process.

(i) When a customer places an order, the customerbalance is increased by the order amount. (ii) (ii) When a customer makes a payment, the customerbalance is decreased by the payment amount.

That is, the customerbalance in the above table stores the current balance at any instant in time. Thus, the company can obtain the current balance owed by a customer at the time of inquiry.

The finance manager of this company is interested in an aged balance for each customer. That is, he/she wants the customer balance to be split into categories like <30-day, 30-60day, and >60-day balances. For example, if a customer has not paid $1000 for orders placed more than 60 days ago, then this $1000 should be in the category 60-day balance.

Quesion1: Suggest a set of one or more database tables to produce the aged balance report.

Question2: Briefly describe how these tables will be updated and how the aged balance report can be generated using these tables.