MySQL Data Cleaning Project

I have an active MySQL database that has gathered duplicates, incomplete fields, and a few broken relationships over time. I need focused help cleaning this existing data set so every table is consistent and reliable again.
Your task is limited to data cleaning; I will handle any future insertion work or query tuning myself.

Deliverables
• A cleaned SQL dump or set of migration scripts ready for direct import
• A short report outlining the issues you found, the steps you took to fix them, and any preventive measures you suggest

Acceptance Criteria
• Duplicate rows and orphaned records are removed
• Mandatory fields contain valid, properly formatted values
• All foreign-key relationships pass integrity checks without errors

Feel free to work with MySQL Workbench, phpMyAdmin, or command-line tools—whatever you prefer—provided the final scripts execute cleanly on MySQL 8.
When you reply, let me know a brief example of a similar MySQL cleaning job you’ve completed and roughly how long you’ll need once I send over the schema and sample rows.