This is a text description of xipug003.gif, which shows a star join schema with the following four tables:

• Time Dimension, which contains these columns:

  • time_ID

  • day

  • month

  • quarter

  • year

• Loan Procurement Fact, which contains these columns:

  • time_ID

  • product_ID

  • loan_service_ID

  • loans_offered

  • loans_rejected

  • loan_amount

• Loan Procurement Dimension, which contains these columns:

  • product_ID

  • product_name

  • product_type

  • product_cost

• Loan Service Dimension, which contains these columns:

  • loan_service_ID

  • loan_service_name

  • loan_service_address

The Loan Procurement Fact table is joined to the Time Dimension table using the time_ID column; it is joined to the Loan Procurement table using the product_ID, and is joined to the Loan Service Dimension using the loan_service_ID.