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

[Karsten Hilbert]

> 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

Karsten
-- 
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346