Postgres Pro
Downloads
Home   >   mailing lists

Re: Data (Table) Structure Question - Mailing list pgsql-novice

From Duncan Garland
Subject Re: Data (Table) Structure Question
Date
Msg-id MBEPKEEDMKGCDODFKLPPGEGGDGAA.duncan.garland@ntlworld.com
Whole thread Raw
In response to Data (Table) Structure Question  (<operationsengineer1@yahoo.com>)
List pgsql-novice
Tree view 
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

pgsql-novice by date:

Previous
From: "A. Kretschmer"
Date:
Subject: Re: Performances
Next
From: Bricklen Anderson
Date:
Subject: Re: [ADMIN] Performances