-
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...
10 -
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....
-
-
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...
-
Recycle, Reduce, Reuse
The model below is an example of an Event and Event Line concept, a familiar structure in many of...
