Data Separation – Part 2Posted: November 2, 2011
Before pressing on with the surgery on my data file, I spent a couple of hours tidying up the relationships graph in the Interface file, as this is where most of the relationships will remain after the conversion.
I use the “squid” method of drawing the relationships graph, whereby each table has its own “anchor” TO, with all relationships descending from this table shown to the right of it. This method has its critics, mainly because of the number of TOs for each table, but it keeps things nice and clear. Anyway, it works for me, and here’s part of it, with each table’s squid in its own box, and the TO names reassuringly italicised to show that they are referring to the external data source, “Focus_DATA”.
So far, so good. Now on with the surgery.