[Fix Data Integrity & Insights](https://freelancer.com/projects/40729207.html)

[Fix Data Integrity & Insights](https://freelancer.com/projects/40729207.html) My production platform is already up and running, but the dashboards and analytical views are no longer trustworthy because duplicate records keep sneaking into the database. I need someone to track down why those duplicates are created, clean the existing tables, and put in place solid safeguards so the issue never resurfaces. Once the data is reliable again, the insight section on the platform needs fixing Deliverables (acceptance criteria): • A cleaned database with zero duplicate records in the affected tables • Preventive mechanisms deployed (constraints, triggers, or service-level fixes) that block future duplicates • Updated insight queries or materialized views that now return accurate counts ...