What is the nature of the application (OLTP or OLAP), when you design database? When you begin your database design plan the important thing to investigate is the way of the application you are planning for, is it Transnational or Analytical. You will discover numerous engineers as a matter of course applying standardization rules without considering the way of the application and afterward later getting into execution and customization issues. As said, there are two sorts of uses: exchange based and scientific based, how about we comprehend what these sorts are.Transnational :- In this sort of utilization, your end client is more inspired by CRUD, i.e., Creating,Reading ,Updating , and Deleting records. The official name for such a sort of database is OLTP. Analytical:- In these sorts of utilizations your end client is more intrigued by analysis , reporting, forecasting , and so on. These sorts of databases have a less number of additions and Updation. The principle goal here is to bring and break down information as quick as could be expected under the circumstances. The official name for such a sort of database is OLAP.