we need to normalize this database to reduce the amount of inconsistencies between databases.