Re: Tables cities and table user

From: The Natural Philosopher <tnp_at_invalid.invalid>
Date: Tue, 12 Feb 2019 15:40:23 +0000
Message-ID: <q3upd7$uir$6_at_dont-email.me>

On 12/02/2019 12:58, Kees Nuyt wrote:
> On Mon, 11 Feb 2019 18:06:27 +0000, The Natural Philosopher
> <tnp_at_invalid.invalid> wrote:
>

>> On 11/02/2019 17:10, Kees Nuyt wrote:
>>> A country can have multiple cities with the same name.
>>> Even a province / state (and maybe even county) can have more
>>> than one city with the same name.
>>
>> but a different unique ID.

>
> Of course, but IMHO an n:m relationship between city and country
> is overkill.
>
e fact that each citye HAS as unique id means you dont need an n:m relationship

A given city can be in only one country. It doesnt martter if youi have a table of a hundred cities all called new york all around the world as long as they have unique ids they will exist in on and one only country/state/region/county/principality or WHY...

-- 
There is something fascinating about science. One gets such wholesale 
returns of conjecture out of such a trifling investment of fact.

Mark Twain

Received on Tue Feb 12 2019 - 16:40:23 CET