Re: Data Model

From: Barbara <bdimple_at_myway.com>
Date: 11 Mar 2006 17:44:00 -0800
Message-ID: <1142127840.858537.301320@p10g2000cwp.googlegroups.com>

matthewdavis1980_at_hotmail.com wrote:
> Gene,
>
> Thanks for your feedback. I agree with your assesment, and if I was
> writing something that needed a more robust addressing system I
> probably would have designed this accordingly.

There is a draft Data Model that corresponds to your requirements on this Page :-

http://www.databaseanswers.org/data_models/judges_and_courts/index.htm

It shows a Normalised Database design with one table ('Consolidated_View') which has all the data in one Table.

HTH B.Dimple
Senior DBA Received on Sat Mar 11 2006 - 19:44:00 CST