A bank wants to build a data warehouse for storing and analyzing data about all loans issued by them.

• Every loan has one or more borrowers, a starting date, a type (e.g., fixed rate or one of different types of variable rate), the branch of the bank where the loan was issued, the interest rate at the start of the loan, and the amount.
• For every loan the purpose of the loan is recorded; e.g., to buy a car, a house, a personal loan, etc.
• When a borrower applies for the loan, different discounts on the interest rate may be awarded; e.g., fidelity discount, discount because the borrower also bought some additional insurances, VIP discount, etc. For one loan, multiple discounts may apply. The amount of discount is independent of the branch. Every discount that has been awarded needs to be stored.
• When the loan ends, this is stored as well, together with an indication if the loan was fully repaid or the borrower defaulted.
• For the borrowers, their date of birth, family status, monthly income, number of children and address is stored.

The following questions are prototypical for the type of query analysts want to answer based on the data warehouse:

1. Give the average interest rate before discount at the start of the loan, per loan type and branch.
2. For all branches, give the minimum, maximum and average interest rate per loan type and purpose.
3. Give the number of loans per branch and per amount category. The amount category depends on predefined thresholds; amounts are divided into the following classes: very high, high, medium, low, and very low.
4. Give the percentage of defaulted loans per year and per city of the branch where the loan was issued.

Based on the above description Make a dimensional model for the data warehouse indicating:

1. What is/are the Facts? Define measures. (2 PTs)
2. What are the Dimensions? Illustrate hierarchies if any. (2 PTs)
3. Draw the star schema for the multidimensional model. (1 PT)

please assignment solve, deadline 15 march.