Analysis of bank management system (Financial Institution)

This week, as you continue with the data modeling and data governance analysis for your case study on bank management systems (Financial Institution), you will perform the following task:

Start with your data model fromWeek 2and now think in terms of creating a data warehouse or data mart data set from your database. To do so, you will first need to rethink your logical schema and transform it from an OLTP type of schema to an OLAP type of schema based on a dimensional data model. Next, you will need to add a temporal property to your data model, which means you must decide how to incorporate the notion of time. Use the dimensional data architecture concepts you learned this week for this assignment.