Question

A bank ‘xyz’ wants to know about its popularity among the residents of a city ‘ABC’ on the basis of the number of bank accounts each family has and the average monthly account balance of each person. Briefly describe the steps to be taken for collecting data and what results can be checked through the processing of the collected data.

Answer 1

1. Data collection
   Banks already have data about customers so this step is not required.
2. Data Storage
   Bank already has data stored in its database.
3. Data Processing
   a) A bank employee will prepare a report using the SQL queries to get all those customers that are having accounts in that area along with the Monthly Average Balance of every customer.
   b) After preparing the report the data will be compared with available customer data from other branches of this bank. This comparison will directly show the popularity of that branch in the area.