Question: It's difficult for me You have been asked to develop an interactive system for online banking system. The client side would accept from the user
You have been asked to develop an interactive system for online banking system. The client side would accept from the user the account number and the amount of money being deposited which will then be passed on to the server. Upon receiving the data from the client, the server will connect to the database which holds records consisting of customer name, balance and account number, and use the account number provided by the client to search the database for a matching record. Once the matching record is found, the balance will be retrieved from the database and added to the deposited amount provided by the client. The new balance will then be used to calculate the interest. The new balance and the interest will be sent back to the client where they will be displayed on screen for the user. The interest rate used would be 0.02 which is stored on the server. If a matching record is not found, send back an appropriate message such as 0 for both the balance and interest. Develop a client/server application to implement this system with the following tasks: Create a database in Access or in any other RDBMS: Create a small database and create a table having three fields: Customer Name, Balance, and Account Number. Insert some data (at least five records). Client side program: The client program will accept from a user a Balance and Account Number and sending both of them to server which will then act according to the scenario presented above. Server side program: Develop a server side program which will do the following: (i) Make connection to the database (ii) Retrieve the data from the table as per the searching criteria (iii) If match is found, then retrieve the balance and do the necessary calculations as per scenario (iv) If match is not found, then send an appropriate error message (v) Close the connection with the database and client You have been asked to develop an interactive system for online banking system. The client side would accept from the user the account number and the amount of money being deposited which will then be passed on to the server. Upon receiving the data from the client, the server will connect to the database which holds records consisting of customer name, balance and account number, and use the account number provided by the client to search the database for a matching record. Once the matching record is found, the balance will be retrieved from the database and added to the deposited amount provided by the client. The new balance will then be used to calculate the interest. The new balance and the interest will be sent back to the client where they will be displayed on screen for the user. The interest rate used would be 0.02 which is stored on the server. If a matching record is not found, send back an appropriate message such as 0 for both the balance and interest. Develop a client/server application to implement this system with the following tasks: Create a database in Access or in any other RDBMS: Create a small database and create a table having three fields: Customer Name, Balance, and Account Number. Insert some data (at least five records). Client side program: The client program will accept from a user a Balance and Account Number and sending both of them to server which will then act according to the scenario presented above. Server side program: Develop a server side program which will do the following: (i) Make connection to the database (ii) Retrieve the data from the table as per the searching criteria (iii) If match is found, then retrieve the balance and do the necessary calculations as per scenario (iv) If match is not found, then send an appropriate error message (v) Close the connection with the database and client
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
