ok guys, i have a database design issue that i hope someone can help me with...

i have to create a database which will take information from different institutions. Basically it needs to track different types of events between two entitys in the database. Parking tickets, child support, court rulings, could be anything really, and the model needs to be extensible...

now my problem is this, the data we are going to be getting is often going to be wrong or incomplete, ie mispelled names, mistyped social security numbers, etc.

i have to keep track of all this info regardless of it's correctness, but also be able to easily find out info about a person when needed....any suggestions?

What do you have for the tables so far and what exactly are you having trouble with?