November 13, 2005 at 11:13 am
Just looking at a database a work fellow did, not sure on his skill level.
In his database, he has many concatenated Primary keys (PK), frankly he has made is foreign keys, primay as well. (PK is that it has a yellow key next to field name).
My understanding "concatenated Primary keys" should be limited as much as possible? Whats your thoughts on many concatenated Primary keys ???
November 14, 2005 at 2:29 pm
Can you show us a few exemples on the questionable keys in their tables?
November 15, 2005 at 5:19 am
Concatenated PK's are sometimes necessary. Before I comment more, I too would like to see the example you're talking about.
November 16, 2005 at 7:04 am
Did he use a modeling tool in creating his database? I am once again working with Erwin after a few years away from it, and I am finding that when one creates a one to many relationship, Erwin includes the primary key from the parent table in the primary key of the child table. Very Annoying.
November 16, 2005 at 11:12 am
How does one post examples of a database relationship diagram ??
November 16, 2005 at 11:38 am
post the DDL of the 2 related tables
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply