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.)

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
F02	Party Planning	12/14/2006	Office

Table A

Donor_ID	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

Step1: 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