OLTP (online transaction processing) VS OLAP (online analytical processing) are both types of production databases, however they have some key…