DATA GENERATION:
- A Bank keeps two tables for all the borrowings done by the credit card customers:
A. Table containing the credit limit
Fields are:
ClientID SpendLimit (in Rs)
B. Table containing the transactions (+ve sign means amount deposited, -ve sign means amount spent)
Fields are;
Date, ClientID, TransactionAmount (+ve or -ve)
Assignment 1:
Generate data for 15 clients (C1 to C15) so that each one has a limit between 500 to 5000 (only a multiple of 50)
Generate transaction table so that each of these clients do around 50 transactions every month spending money between 100 to 500 Rs each transaction
Generate data in transaction table so that each client deposits 1000 rs on 1st of every month
Assignment 2:
Once the tables of assignment 1 are done, create an extract column 'Breached'
in the Transaction table. This field should show whether the credit limit of client is breached by that transaction or not.
