I have a fairly simple question about natural/surrogate key usage in a well-defined context wich manifests itself often, and that i'm going to illustrate.
Let's assume you are designing the DB schema for a product using SQL Server 2005 as DBMS. For the sake of simplicity let's say there are only two entities involved, wich have been mapped to 2 tables, Master and Slave. Assume that:
The question is: how would you design keys/constraints/references for those tables? Would you rather (argumenting your choice):
As for me I'd go with option 2), mainly because of assumption 3) and performance-wise, but I'd like to hear someone else's opinion (since there is quite an open debate on the topic).
thank you