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.
Companies using Lean Six Sigma approach realize various projects within this activity. These projects differ from usual project conception in several aspects. Let`s take a look how ObjectGears can help with managing Lean Six Sigma projects portfolio.