• 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 source table to dimension and fact tables
  • Use Diagram below for data to make star schema:

• STEP 2: Create tables based on the star schema created in step 1 (using 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 operational system) like the example below:

"Helping Hand ER Diagram (for Operational Database) lid Vid Calls + INDIVIDUAL Iname Vname Damount VOLUNTEER Isex PHONDONATION Makes Vsex Makes Causes Did MAILDONATION Ddate Damount Writes To Works OutOf Ddate Causes Lid Did LOCATION + WorksOutOf Eld + EMPLOYEE Laddress Lname Ename Esex Helping Hand" Operational Database INDIVIDUAL lid Iname Isex LOCATION Lid Name Address 111 Joe Tina M F 1 2 222 HO 123 Oak St Branch1 67 Pine Rd EMPLOYEE Eid VOLUNTEER Vid Ename Esex Lid Vname Esex Lid Bob Ell E22 M F 1 2 VII V22 Bill Linda M F Marv 2 PHONE DONATION PDid Date MAIL DONATION MDid Amount Vid lid Date Amount Eid lid 1 1 2 1.1.2001 1.2.2001 $100 $100 V22 VII E22 1.1.2001 1.2.2001 $500 $400 222 111 222 E11 CALLING Vid WRITTING Eid lid lid VI1 V11 V22 V22 111 222 111 222 Ell E11 E22 E22 111 222 111 222 "Helping Hand ER Diagram (for Operational Database) lid Vid Calls + INDIVIDUAL Iname Vname Damount VOLUNTEER Isex PHONDONATION Makes Vsex Makes Causes Did MAILDONATION Ddate Damount Writes To Works OutOf Ddate Causes Lid Did LOCATION + WorksOutOf Eld + EMPLOYEE Laddress Lname Ename Esex Helping Hand" Operational Database INDIVIDUAL lid Iname Isex LOCATION Lid Name Address 111 Joe Tina M F 1 2 222 HO 123 Oak St Branch1 67 Pine Rd EMPLOYEE Eid VOLUNTEER Vid Ename Esex Lid Vname Esex Lid Bob Ell E22 M F 1 2 VII V22 Bill Linda M F Marv 2 PHONE DONATION PDid Date MAIL DONATION MDid Amount Vid lid Date Amount Eid lid 1 1 2 1.1.2001 1.2.2001 $100 $100 V22 VII E22 1.1.2001 1.2.2001 $500 $400 222 111 222 E11 CALLING Vid WRITTING Eid lid lid VI1 V11 V22 V22 111 222 111 222 Ell E11 E22 E22 111 222 111 222