To create an Operational Database in 3rd normal form, create a Multidimensional Model for Datamart, perform ETL (Export-Transform-Load) using T-SQL and SSIS methods, create a Multidimensional Cube using analysis service SSAS, create Data Mining structure and applying Machine Learning algorithm.
Tools and Language: Microsft SQL Server Management Studio, SQL