The surrogate-key tag has no wiki summary.
2
votes
2answers
245 views
Replacing composite key with surrogate
I have the following table that has a couple of million rows in it and is 99% fragmented virtually all of the time. My plan was to insert a IDENTITY field as a surrogate key to replace the current ...
1
vote
2answers
73 views
Problem with a surrogate key?
I am working with an application for students management. For the student's table I used a surrogate key (auto increment id). The problem I face with the surrogate key is when the user wants to show ...
0
votes
2answers
72 views
Can a surrogate key and a primary key be in the same table?
For example we have:
Surrogate key: ABC123
Primary key: 1
Name: James
Is this legit in a Data Warehouse table?
0
votes
1answer
37 views
Create two tables with identical superkeys?
I have an existing table called Realms. This has the superkey rlmID (just a surrogate key). We are planning to add tables that group realms in some context -- let's just calll them RealmGroups. ...
0
votes
1answer
86 views
Is it acceptable to have a surrogate/primary key of one table be the primary/foreign key of another table?
For my purposes I'm trying to apply this to Microsoft SQL, but would like to know if there are restrictions for other DBMS regarding this.
I don't know how to represent UML as ascii characters so if ...
