[thelist] DB design question
Ken Schaefer
ken at adOpenStatic.com
Sat Dec 7 03:41:01 CST 2002
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "rudy" <r937 at interlog.com>
Subject: Re: [thelist] DB design question
: so let me pose a question --
:
: if you create a surrogate primary key, like an autonumber (which i think
: makes the most sense in this example of property addresses), then what's
the
: "real" key? the address, right? including apartment number, and probably
: city, too, right?
:
: but how is the database supposed to know that the address is the "real"
: primary key, if you use an autonumber as the primary key?
:
: and so the question is, what's to stop the table from having two rows with
: the exact same address?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
You could create a data domain constraint. :-)
Cheers
Ken
More information about the thelist
mailing list