How to design database containing persons with multiple aliases and partial names

I’m a moderately skilled Excel user, who’s been tasked with creating a database for a law enforcement agency. The database’s main purpose is to contain names of suspects, which organisation or organisations they work for, and which events they can be connected to, for example a store robbery.

My main problem is that a lot of the data that needs to be put into the database, only has fragments of suspects’ names. One report can have a person’s name as “Michael Sorrentino”, another only mentions a “Sorrentino”, and a third report mentions somebody with the alias “The Situation”, which may be just one of several aliases for “Michael Sorrentino”. Multiple persons can both have the same alias as other persons, or have multiple aliases of their own.

The database should also make it possible to connect a person to multiple events. I suspect a design akin to an inventory database would be suitable for this purpose.

Making this information comprehensible and accessible for the analysts who are going to use it is beyond Excel and is a task more suited for databases, where Microsoft Access is what I currently have at hand.

How should I go about designing this database?

submitted by /u/MongooseMongolia
[link] [comments]

Posted on

How to design database containing persons with multiple aliases and partial names

I’m a moderately skilled Excel user, who’s been tasked with creating a database for a law enforcement agency. The database’s main purpose is to contain names of suspects, which organisation or organisations they work for, and which events they can be connected to, for example a store robbery.

My main problem is that a lot of the data that needs to be put into the database, only has fragments of suspects’ names. One report can have a person’s name as “Michael Sorrentino”, another only mentions a “Sorrentino”, and a third report mentions somebody with the alias “The Situation”, which may be just one of several aliases for “Michael Sorrentino”. Multiple persons can both have the same alias as other persons, or have multiple aliases of their own.

The database should also make it possible to connect a person to multiple events. I suspect a design akin to an inventory database would be suitable for this purpose.

Making this information comprehensible and accessible for the analysts who are going to use it is beyond Excel and is a task more suited for databases, where Microsoft Access is what I currently have at hand.

How should I go about designing this database?

submitted by /u/MongooseMongolia
[link] [comments]

Posted on