14 reputation
2
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?