I am a fraud researcher and need a better way to organize my data. Basically my data set falls into to categories, victims and suspects.
For victims I have don't always have a name, sometimes I have pieces of data like account data, sometimes I have different data points. What I'd like to have is a db and front-end that lets me enter these data points easily and be able to link them together.
For example I may have an address & bank account info, then weeks later I come across a cc tied to that address. Those data points need to be linked and searchable. So when I pull up say the address I see what is linked.
I also want to track where I got the individual data point from (typically a web site, but info comes from various places).
Suspects should also be track, their data is similar but often they have multiple addresses where most victims have one, also they may have several names tied to one address, or the address may have subtle variations.
I don't want to give away to much in this summary but can provide more details if you are interested.
I think the project itself is easy, it just needs some serious thought around the schema.