[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
: "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. :-)


More information about the thelist mailing list