Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Null vs. Zero for Primary Key
Message
From
19/01/2011 15:50:50
Kevin Goff
Pennsylvania, United States
 
 
To
19/01/2011 15:33:21
Mike Cole
Yellow Lab Technologies
Stanley, Iowa, United States
General information
Forum:
Microsoft SQL Server
Category:
Database design
Title:
Re: Null vs. Zero for Primary Key
Miscellaneous
Thread ID:
01496573
Message ID:
01496585
Views:
61
What about an optional mailing address FK?

Hi....most (but certainly not all) address tables are normalized in 1-many relationships....

e.g. Person (PersonID)
PersonAddress (PersonAddressID, PersonID, AddressTypeID, AddressLine1, City, etc., StartDate, EndDate, etc.)

several variations on this, but you get the drift....

So in this case, wouldn't be relevant.
"Run, you clever boy....and remember"
https://www.youtube.com/watch?v=8U4Y2Uv8ArM

"My survival...my living proof"
https://plus.google.com/photos/117162300364810952313/albums/5876836271056272097/5876836294121419858?banner=pwa&pid=5876836294121419858&oid=117162300364810952313
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform