[Top][All Lists]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [Gnumed-devel] Questions re database schema:street:address:urb:count

From: Karsten Hilbert
Subject: Re: [Gnumed-devel] Questions re database schema:street:address:urb:country
Date: Tue, 31 Aug 2004 18:38:48 +0200
User-agent: Mutt/

> An urb is definitely defined by urb name and country -> table for urbs

> A street is definitely defined by urb plus postcode plus street name -> table 
> for streets

> And address is definitely defined by house number / flat number plus street 
> -> 
> address table

> There is no place for (sub)urb in the address table if e follow the rules for 
> normalization!
Huh ?!?

Of course there is:

1) make sure what is *meant* by suburb, eg. "a part of a larger
   locality, used to be a separate locality however far back
   in time"

2) make it an attribute of street since street+urb+postcode
   definitely defines which suburb we are talking about

GPG key ID E4071346 @
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346

reply via email to

[Prev in Thread] Current Thread [Next in Thread]