2. (25.5 points) The data below tracks information about interviews scheduled as a part of a college career fair. The raw data is available on ICON as interviews.xlsx". a. Construct a single graphical relation (i.e., one row of boxes) for INTERVIEWS and diagram the functional dependences. Make sure to include primary keys, foreign keys, and relationships, if needed. Do not create any new, surrogate keys. b. What is the current normal form of the data (before normalization)? Be specific with your reasoning. Leave your answer as a textbox in the same sheet as part a. c. Break down INTERVIEWS into a set of third normal form relations. Diagram the functional dependencies and relationships using arrows with different color or style. Do not create any new, surrogate keys. Create this diagram on the same sheet as part a. INTERVIEWS StudentID Name GPA CompanyID Company Industry InterviewerID Interviewer Alum Interview Time 1001 Felicity Porter Major Computer Science Business 3.9 3003 | Google Technology 4001 Dawn Tinsley Y 9:00 AM 1002 Noel Crane 3.7 4003 N 9:00 AM 1005 Business 3.4 Accounting Technology Healthcare Ben Covington Julie Emrick Y 10:00 AM Tim Canterbury Dawn Tinsley Chris Finch 4001 4005 3002 Deloitte 3003 Google 3006 Wellmark Northwestern 3001 Mutual 1006 Nursing 3.5 Y 10:00 AM 1002 Noel Crane Business 3.7 Finance 4004 David Brent N 11:00 AM 1001 Felicity Porter 3.9 3004 Yahoo Technology 4002 Gareth Keenan N 1:00 PM Computer Science Public Health 1003 Elena Taylor 3.8 3002 Deloitte Accounting 4003 Tim Canterbury N 1:00 PM 1006 Julie Emrick Nursing 3.5 3005 Humana Healthcare 4006 1:00 PM 1004 Javier Quintata | Nursing 3.6 3005 Humana Healthcare 4006 2:00 PM Jennifer Taylor- Y Clark Jennifer Taylor- Y Clark Jennifer Taylor- Y Clark Tim Canterbury N 1003 Elena Taylor Public Health 3.8 3005 Humana Healthcare 4006 4:00 PM 1005 Ben Covington Business 3.4 3002 Deloitte Accounting 4003 4:00 PM 2. (25.5 points) The data below tracks information about interviews scheduled as a part of a college career fair. The raw data is available on ICON as interviews.xlsx". a. Construct a single graphical relation (i.e., one row of boxes) for INTERVIEWS and diagram the functional dependences. Make sure to include primary keys, foreign keys, and relationships, if needed. Do not create any new, surrogate keys. b. What is the current normal form of the data (before normalization)? Be specific with your reasoning. Leave your answer as a textbox in the same sheet as part a. c. Break down INTERVIEWS into a set of third normal form relations. Diagram the functional dependencies and relationships using arrows with different color or style. Do not create any new, surrogate keys. Create this diagram on the same sheet as part a. INTERVIEWS StudentID Name GPA CompanyID Company Industry InterviewerID Interviewer Alum Interview Time 1001 Felicity Porter Major Computer Science Business 3.9 3003 | Google Technology 4001 Dawn Tinsley Y 9:00 AM 1002 Noel Crane 3.7 4003 N 9:00 AM 1005 Business 3.4 Accounting Technology Healthcare Ben Covington Julie Emrick Y 10:00 AM Tim Canterbury Dawn Tinsley Chris Finch 4001 4005 3002 Deloitte 3003 Google 3006 Wellmark Northwestern 3001 Mutual 1006 Nursing 3.5 Y 10:00 AM 1002 Noel Crane Business 3.7 Finance 4004 David Brent N 11:00 AM 1001 Felicity Porter 3.9 3004 Yahoo Technology 4002 Gareth Keenan N 1:00 PM Computer Science Public Health 1003 Elena Taylor 3.8 3002 Deloitte Accounting 4003 Tim Canterbury N 1:00 PM 1006 Julie Emrick Nursing 3.5 3005 Humana Healthcare 4006 1:00 PM 1004 Javier Quintata | Nursing 3.6 3005 Humana Healthcare 4006 2:00 PM Jennifer Taylor- Y Clark Jennifer Taylor- Y Clark Jennifer Taylor- Y Clark Tim Canterbury N 1003 Elena Taylor Public Health 3.8 3005 Humana Healthcare 4006 4:00 PM 1005 Ben Covington Business 3.4 3002 Deloitte Accounting 4003 4:00 PM