I would start by writing down everything you know about crime. For example:Police, Detectives, Locations, CrimeType, Crime Instance etc.
Theses could be your tables.
Link the data in the tables to make it into a database. The data in the tables may be something like:
Location: Name, Address, Type, creationDate, user
Crime: Name, Severity, Punishment, creationDate, user
CrimeIntance: Crime, Location, Date, Detective, creationDate, user
etc, etc – use your imagination
4
solved Crime Data Warehouse [closed]