On Tue, Apr 26, 2011 at 11:40 AM, Paul McNett <[email protected]> wrote: > On 4/25/11 2:13 PM, Stephen Russell wrote: >> Would you attempt to normalize this structure to Locations, People, >> ContactTypes? > > Would doing so simplify the application meaningfully? If so, then I would > argue for > it. If not, then no. ----------------------------------
Very loaded answer there. Is it easier to leave it alone and continue to knob together duplicate additional tables as needed? Sure it is easier because we can just copy and paste schema as well as stored procedures and poof it is working after a tiny bit of find and replace. This is workers compensation so it is loaded with oh by the way type of "stuff" that grew along the way from 95 to today. If you get hurt on the job you have an employer. In a bizarre case this same company may self insure themselves instead of putting in a claim to their real insurance carrier. So I have Identical data in two tables that reference the same people we have to deal with. Yes I would need to dupe "Maggie West" in contacts because there is a key to define what business area you are from. The fkey back to Employers is different then the one to Payers. If we used GUID instead of INT I could have the same one row but this is an INT based shop for all IDs so I need the pair of them. -- Stephen Russell Unified Health Services 60 Germantown Court Suite 220 Cordova, TN 38018 Telephone: 888.510.2667 901.246-0159 cell _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
