How to normalize data in ObjectGears
Every database system administrator or developer has probably met following situation already couple of times. You start with a text field that gives users flexibility in data input but realize later on that you would rather need a reference to a master data table (foreign key), in order you address data quality and denormalization. E.g. you need to record other properties of the referred entity or link it to other information from your system. How ObjectGears can help with solving this issue? That`s the topic of this article.