STEP 1: Create a star schema diagram that will enable Helping Hand to analyze the donations they receive The fact table will include: for every individual donation - the amount made. The star schema will include all dimensions that can be useful for analyzing donations. The only data source available is the Helping Hand operational database. Submit both the ER model of the source and the star schema as one file: use outlines of matching colors to illustrate mapping from the source table to dimension and fact tables

STEP 2: Create tables based on the star schema created in step 1 (using a word or excel, you don't have to create actual relational database this time, and populate those tables manually with data extracted from the underlying operating system Helping Hand ER Diagram Ifar nunumtional MatrhunalHelping Hand Operational Database PHONE MAIL

"Helping Hand" ER Diagram Ifar nunumtional Matrhunal "Helping Hand" Operational Database PHONE MAIL