Merging Data Worksheet

Merging Data Worksheet

Read each question carefully and provide the best answer. This worksheet focuses on understanding and merging data from different sources.

Scenario: A school wants to analyze student performance by combining data from two different sources: 'Student_Grades' and 'Student_Attendance'.

Student_Grades Table:

Student ID | Subject | Grade 101 | Math | 85 102 | Science | 92 101 | English | 78 103 | Math | 90 102 | History | 88

Student_Attendance Table:

Student ID | Days Absent | Days Tardy 101 | 3 | 1 102 | 1 | 0 103 | 2 | 2

1. What is the common field between the 'Student_Grades' and 'Student_Attendance' tables that would allow them to be merged?

2. When merging two datasets, the common field used to link them is often called a  .

3. Merging data allows us to get a more   view of the information by combining related details.

4. If you merged the 'Student_Grades' and 'Student_Attendance' tables, what new insights could you potentially gain about student performance?

5. It is always possible to merge any two datasets, regardless of their content.

6. Imagine you have a third table named 'Student_Contact' with the following data:

Student_Contact Table: Student ID | Parent Name | Email 101 | Jane Doe | jane.doe@example.com 102 | John Smith | john.smith@example.com 104 | Alice Brown | alice.brown@example.com

If you wanted to merge 'Student_Grades' and 'Student_Contact', which student's grade data would NOT be included in the merged result if you performed an 'inner join' (meaning only records with matching IDs in BOTH tables are included)? Explain why.