Assignment:
Start with your data model from Week 2 and 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.