Question : I’ve read a lot from both camps in the surrogate vs. natural key debate. What I am struggling […]
Tag: surrogate-key
What are the consequences, positive or negative, to having a surrogate primary key for a table which already has a guaranteed unique column? [closed]
Question : Closed. This question needs to be more focused. It is not currently accepting answers. Want to improve this […]
Composite primary key plus a separate (surrogate) id column for foreign key references
Question : I am trying to build a database about locations like so: Country → Region → Town Countries will […]
What are the disadvantages of using surrogate keys? [closed]
Question : Closed. This question needs to be more focused. It is not currently accepting answers. Want to improve this […]
Do natural keys provide higher or lower performance in SQL Server than surrogate integer keys?
Question : I’m a fan of surrogate keys. There is a risk my findings are confirmation biased. Many questions I’ve […]
Surrogate keys as Foreign Keys
Question : I have a question about Surrogate keys, say i have two tables(in sql server): Table A: Student_ID, Name, […]
Foreign keys – link using surrogate or natural key?
Question : Is there a best practice for whether a foreign key between tables should link to a natural key […]
Reassigning surrogate keys?
Question : I have a few tables with surrogate keys (SERIAL PRIMARY KEYs unique to each tables). These tables are […]
M:M Table Design – Use of PK
Question : I have a many-to-many table that contains id’s from 2 related tables. For creating a primary key on […]
A question regarding the performance of normalization
Question : I am sorry this is such a newb question, but it is one thing I am having a […]
- 1
- 2