Q5. Design Question :

1. Given one webserver that can handle upto 6 month SQL Query Data (or else it will give memory error)
2. Suppose we are having multiple SQL tables and that gives output something like
{
key : k1
date: 31-07-2018
Opening Balance: xxxx
Closing Balance : xxxx
}
There are multiple JSON data in output by SQL Queries.
3. Design schema of tables to handle Queries.
4. Our Task is to find the closing and opening balance between given dates(31-03-2018 and 5-08-2018).

Question

Q5. Design Question  : 

1. Given one webserver that can handle upto 6 month SQL Query Data (or else it will give memory error)
2. Suppose we are having multiple SQL tables and that gives output something like 
{
  key : k1
  date: 31-07-2018
  Opening Balance: xxxx
  Closing Balance : xxxx
}
There are multiple JSON data in output by SQL Queries.
3. Design schema of tables to handle Queries.
4.  Our Task is to find the closing and opening balance  between given dates(31-03-2018 and 5-08-2018).

Sigiloso · Accepted Answer

Hint :  1. Each Month_year will be a separate table that stores all transaction
               2. Think of Account statement of your account and if u find statement between some dates. how it works.
              3. you have to calculate from starting date of company transaction stored

Quikr India

Pergunta de entrevista da empresa Quikr India

Resposta da entrevista

Empresas seguidas

Buscas de vagas