17) GEN, CA GEN data modelling best practice

Denormalization of tables whenever the access equals or exceeds three levels but can be avoided by having additional attributes.

Eg: To get attrib1 table T1 and attrib3 from table T3 the normal sequence would be:

Read T1 Where A1 = local view lcl_a1

When Successful

            Read T2 Where current view and

                        A2 = local view lcl_a2

            When Successful

                        Read T3 Where current view and

                                    A3 = local view lcl_a3

                        When Successful

                        ...

End Read

Instead by storing the extra attrib1 attribute in Table T3, these three reads can be avoided.

Note: There is of course the need to update this field as when the field is updated in table T1.