Re: Data (Table) Structure Question

From: "Duncan Garland" <duncan(dot)garland(at)ntlworld(dot)com>
To: "Pgsql-Novice-Owner" <pgsql-novice-owner(at)postgresql(dot)org>
Subject: Re: Data (Table) Structure Question
Date: 2006-11-24 10:57:05
Message-ID: MBEPKEEDMKGCDODFKLPPGEGGDGAA.duncan.garland@ntlworld.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi,

The second structure is more normalised and it's a good rule of thumb to
normalise your data. Does anything else need to be split out? For instance
can a person have more than 1 address? Do you need an address history?

Regards

Duncan

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Allison 2006-11-24 12:25:16 Triggers and Functions
Previous Message operationsengineer1 2006-11-24 10:10:48 Data (Table) Structure Question