Data generation

naveenboss — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Data generation

jonathandienst — Thu, 30 May 2019 06:10:05 GMT

And your question is?

naveenboss — Thu, 30 May 2019 06:13:55 GMT

i want to generate complete data as per conditions given.