Problem 1 - Using the following three tables create a final view to answer the given query. Make sure the four steps of the process are following for full credit (Step 1 - combine, Step 2 - copy and reject, Step 3 - remove redundant fields, Step 4 - Answer the Query. Only use the space you need in the blank tables to create your views.) 0 Grading Rubric: (Total points) 1 point for correctly combining each record in Step 1 1 point for correctly combining each field in Step 1 1 point for correctly rejecting each record in Step 2 1 point for correctly listing the non-rejected records in Step 3 1 point for correctly removing redundant fields in Step 3 3 points for answering the query correctly in Step 4 . . . Query: Give me the Fund Name and Email Address for the customer who donated $50.00 FundID Fund_Name Event_Date Type F16 Casino Night 05/11/2006 Office F23 Fun Run 09/27/2007 Charity FO2 Party Planning 12/14/2006 Office Table A Donor JD Customer_Name Email Address D21 Michael Scott Michael.scott@dundermifflin.com D15 Creed Bratton Creed.bratton@creedthoughts.org C13 Dwight Schrute dwight.schrute@schrutefarms.com Table B FundID Donor ID Amount Donated F16 D15 $50.00 F02 D21 $25.00 Table C Step 1: Combined View (16 + 10) Step 2: Copy and Reject incorrect records (16) Step 3: Remove redundant fields (2 + 3) Step 4: Answer Query (3) Query: Give me the Fund Name and Email Address for the customer who donated $50.00