Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
DATA GENERATION:
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.
And your question is?
i want to generate complete data as per conditions given.