[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