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 ).

NOTE: Detailed steps should be included in the report for JDBC to a Microsoft Access database or in any other RDBMS

Scenario 1 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 wi 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 clien server application to implement this system with the following tasks