| bio | website | |
|---|---|---|
| location | ||
| age | ||
| visits | member for | 1 year, 8 months |
| seen | Jan 2 at 22:02 | |
| stats | profile views | 2 |
|
Oct 31 |
comment |
Is it acceptable to have a surrogate/primary key of one table be the primary/foreign key of another table? I see the point about difficulty to update information with my initial design. I had forgotten about the Unique constraint which is probably then what I will end up using to maintain normalization. |
|
Oct 26 |
revised |
Is it acceptable to have a surrogate/primary key of one table be the primary/foreign key of another table? Wasn't aware of the DB design tag. Couldn't find UML tag so that sounds like most appropriate. |
|
Oct 26 |
asked | How do I represent in UML a change of field name from one table as primary key to another as the foreign key? |
|
Oct 26 |
asked | Is it acceptable to have a surrogate/primary key of one table be the primary/foreign key of another table? |
|
Oct 14 |
comment |
What is the concept of a “master table”? @ShawnMelton & (Pete Carter) I'm thinking it must have derived from a mix of an existing term used in the industry and something of their own reference. I thought there was an easier answer. I think those that know the truth are no longer employees. The legacy of predecessors I guess. |
|
Oct 14 |
comment |
What is the concept of a “master table”? @PeteCarter & (Shawn Melton) I'm thinking it must have derived from a mix of an existing term used in the industry and something of their own reference. I thought there was an easier answer. I think those that know the truth are no longer employees. The legacy of predecessors I guess. |
|
Oct 14 |
comment |
What is the concept of a “master table”? @MaxVernon I did ask and they only could tell me what is on that table, but not where the name came from. |
|
Oct 13 |
asked | What is the concept of a “master table”? |
|
Oct 13 |
comment |
What is an industry standard method for verifying openquery connection is open prior to running queries? Is sp_testlinkedserver not to be used? |
|
Oct 13 |
awarded | Scholar |
|
Sep 9 |
awarded | Student |
|
Sep 8 |
asked | What is an industry standard method for verifying openquery connection is open prior to running queries? |