-
Is stability an important property for a candidate key on the logical data model?
A candidate key is an attribute (or set of attributes) that identifies an entity. A candidate key is either...
0 -
Having the same primary key in two or more logical entities
You are a data modeler designing a data mart, and have come across at least two different entities on...
-
The Person Identifier
A university needs a unique identifier for an individual. There is a Person Identifier assigned by the university to...
-
To surrogate key or not to surrogate key, that is the question
As a data modeling expert in your company, you are frequently being asked modeling advice. On your way to...
-
Decoding codes
You are responsible for modeling best practices in your company, and have noticed three different ways for modeling codes....
-
Null AK?
An Alternate Key (AK) is a unique identifier for an entity instance that has not been selected as the...
-
Subtype key
A subtype inherits its primary key from its supertype. If the supertype is Party for example, we copy the...
-
Customer Id
I was showing examples of both complete and incomplete definitions during a recent training class, when I shared the...
-
Is GUID good?
A GUID is a globally unique identifier for a database. There is much interest lately in using the GUID...
-
Swimming in Rough Water
I haven’t opened my bank statements since September, my favorite haunts are going out of business, and budgets have...