Why to build or create a data model? To avoid redundancy of data in a OLTP database. In Data Warehousing,…