Exp	Designed data models and conducted Normalization and De-Normalization of the data as per the Online Transaction Processing (OLTP) and Online Analytical processing (OLAP) frameworks respectively for data analysis.