Consider the introduction of controlled redundancy

• objective:relaxing the normalization rules to improve performance

• join operation

• draw back of denormalization

• makes implementation more complex
• often scarifices flexibility
• speed up retrievals but slows down updates

• if often read, little update, denormalization is a possible option

• Step 7.1-7.7
• Implications and solutions