Scribd Logo
Upload

Welcome to Scribd!

  • 97 views

    Karnataka Bank Ltd. Transaction Processing System (TPS) Malleshwaram Branch-560087

    Uploaded by

    Ragavendra Rags
    This document contains account information for Ragavendra.B including his account number, type of account, date opened, opening balance, transaction dates, transaction types, amounts, and running balance. Formulas were implemented using IF clauses to validate transactions and display error messages for insufficient balances or overdraws. Constraints were also implemented to display error messages.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as DOCX, PDF, TXT or read online from Scribd

    Karnataka Bank Ltd. Transaction Processing System (TPS) Malleshwaram Branch-560087

    Uploaded by

    Ragavendra Rags
    97 views2 pages
    This document contains account information for Ragavendra.B including his account number, type of account, date opened, opening balance, transaction dates, transaction types, amounts, and running balance. Formulas were implemented using IF clauses to validate transactions and display error messages for insufficient balances or overdraws. Constraints were also implemented to display error messages.

    Original Description:

    financial details of KB

    Original Title

    KARNATAKA BANK

    Copyright

    © Attribution Non-Commercial (BY-NC)

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document contains account information for Ragavendra.B including his account number, type of account, date opened, opening balance, transaction dates, transaction types, amounts, and running balance. Formulas were implemented using IF clauses to validate transactions and display error messages for insufficient balances or overdraws. Constraints were also implemented to display error messages.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    97 views2 pages

    Karnataka Bank Ltd. Transaction Processing System (TPS) Malleshwaram Branch-560087

    Uploaded by

    Ragavendra Rags
    This document contains account information for Ragavendra.B including his account number, type of account, date opened, opening balance, transaction dates, transaction types, amounts, and running balance. Formulas were implemented using IF clauses to validate transactions and display error messages for insufficient balances or overdraws. Constraints were also implemented to display error messages.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    You are on page 1of 2

    KARNATAKA BANK Ltd.

    TRANSACTION PROCESSING SYSTEM (TPS) Malleshwaram Branch-560087

    A/C. HOLDER NAME: RAGAVENDRA.B ACCOUNT NUMBER: 985646098 TYPE: DATE OF OPENING: Savings A/C 01-06-2012

    OPENING BALANCE: (Rs.) 5000 DATE 02-06-2012 06-06-2012 04-07-2012 20-07-2012 29-07-2012 01-08-2012 23-08-2012 PARTICULARS TOWARDS SALARY BY CHEQUE ATM WITHDRAWAL BY SELF AT BANK ATM WITHDRAWAL TOWARDS SALARY AT BANK BY CHEQUE CHEQUE NO. 98786 56789 TOTAL FORMULAS IMPLEMENTED: IF clause used for logical condition. OPENING TRANSACTION: =IF(G6+G8-H8<0,"INVALID AMOUNT",G6+G8-H8) REMAINING TRANSACTIONS: =IF(I8+G9-H9<0,"INVALID AMOUNT",I8+G9-H9) and keep on incrementing each cell to get the next transaction amount. CONSTRAINTS IMPLEMENTED: INVALID AMOUNT,PLEASE RE-ENTER, is displayed whenever there is insufficient balance or in case of over draw from existing amount. 10000 5500 27500 8500 2000 500 3000 DEPOSITS (Rs.) Dr 10000 5000 WITHDRAWAL (Rs.) Cr Balance(Rs.) 15000 10000 12000 11500 8500 18500 18000

    RAGAVENDRA.B 09MBI050

    ANALYSIS & DESIGN OF INFORMATION SYSTEM

    ASSIGNMENT ON TRANACTION PROCESSING SYSTEM OF A BANK

    Submitted By Ragavendra.B 09MBI050


    RAGAVENDRA.B 09MBI050

    You might also like