Your question is Validate Data Integrity. Start with the requirements and the two tables on the right.
Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.
What steps would you take to ensure the integrity of your data before analysis?
Use the users and transactions tables to identify transaction records with missing user references, invalid amounts, unsupported or missing statuses, invalid dates, or users whose email appears more than once.
transaction_id, integrity_status, and issue_details.valid only when no listed issue exists; otherwise mark them as invalid.transaction_id ascending.| Column | Type | Description |
|---|---|---|
| user_idPK | INT | Unique user identifier |
| full_name | VARCHAR(100) | User's full name |
| VARCHAR(255) | User email address |
| Column | Type | Description |
|---|---|---|
| transaction_idPK | INT | Unique transaction identifier |
| user_id | INT | Referenced user identifier |
| amount | NUMERIC(12,2) | Transaction amount |
| status | VARCHAR(20) | Transaction status |
| transaction_date | DATE | Transaction date |