Explain data warehouse with figure. Describe fact table and dimension table with example.

From the ICT Ministry Assistant Programmer 2017 – Written exam, question 14 of 14.