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

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