Data Integrity in Dataset Merges | Dataford Interview Questions

How do you ensure data integrity when merging datasets from different sources?

Using the provided student datasets, write a SQL query that compares records by student_id, preserves values from both sources, and classifies each record based on whether the data is consistent, conflicting, or present in only one source.

Output

One row per student ID found in either source.
Include both sources' name, email, and program values, plus integrity_status.
Order by student_id ascending.

Schema

source_a_students

Column	Type	Description
student_idPK	INT	Student identifier from source A
full_name	VARCHAR(150)	Student full name from source A
email	VARCHAR(255)	Student email address from source A
program	VARCHAR(120)	Academic program from source A

source_b_students

Column	Type	Description
student_idPK	INT	Student identifier from source B
full_name	VARCHAR(150)	Student full name from source B
email	VARCHAR(255)	Student email address from source B
program	VARCHAR(120)	Academic program from source B

Your question is Data Integrity in Dataset Merges. Start with the requirements and the two tables in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem