Question

27. Assume that you need to withdraw $100 from your checking account using your bank’s ATM machine. What set of steps does the DBMS need to perform to complete your transaction?

Answer 1

A checking account is a type of bank account that allows you to easily deposit and withdraw money for daily transactions, checking accounts are one of the most liquid bank accounts meaning you have easy access to your money. A checking accounts allows you to unlimitled deposits and withdrawals and may be it have limit for a day to withdrawal.

ATM machine is one of the most secure things in the world. lets us know about ATM architecture

ATM macine consists of a motherboard, input/output module, internet module, cash holder, cash exiter, card reader and cash reader.

So, whenever we need to withdraw money from the ATM machine then we have to insert card to ATM machine where slots are given for inserting a card, then card reader will read the card and will indentify the bank of the card and also all the atm bank is connected to the bank server throgh bank satellite and here bank server is nothing else it a type of database management system (DBMS) where in the DBMS data are stored and always uodated according to account uses. a bank DBMS will allow to store all customer data like account number, debit card number, pin number, bank branch, branch city, branch code, account type, account balance, customer information in other word we can say all the data stored in the DBMS.

Hence whenever a customer uses own debit card in any of atm then atm will read the atm data or card number and it will send to bank server then DBMS will check for this card information is available or not if not then it gives result as error if it is avilable then DBMS send the availabilty result to atm machine then atm machine will ask for your pin which is associated with your card then macbine will send the data to DBMS then DBMS will match the oin with card if match then DBMS allow to give many module to customer like balance enquery, money transfer, deposist money and withdraw money and many more according to availabilty of service but these are basic serives which is available at all the atm machine, then customer have to choose the module which is he want to do, so for withdraw money we have to choose withdrwa module then DBMS will ask for amount after giving the amount then DBMS will again check for daily limit if money withdrawal is in the daily limit or the out of limit if in the limit then it will check for account balance , if withdraw amount is greater than account balance then it will give error message and if lesser than account balance then DBMS will allow to machine to withdraw such amount then after DBMS update the status for that customer account in the DBMS.