Keys and Codes

  • 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...

    0
    Steve Hoberman's first word was "Data"
  • The Person Identifier

    A university needs a unique identifier for an individual. There is a Person Identifier assigned by the university to...

    0
    Steve Hoberman's first word was "Data"
  • 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...

    0
    Steve Hoberman's first word was "Data"
  • Decoding codes

    You are responsible for modeling best practices in your company, and have noticed three different ways for modeling codes....

    0
    Steve Hoberman's first word was "Data"
  • Null AK?

    An Alternate Key (AK) is a unique identifier for an entity instance that has not been selected as the...

    0
    Steve Hoberman's first word was "Data"
  • Subtype key

    A subtype inherits its primary key from its supertype. If the supertype is Party for example, we copy the...

    0
    Steve Hoberman's first word was "Data"
  • Customer Id

    I was showing examples of both complete and incomplete definitions during a recent training class, when I shared the...

    0
    Steve Hoberman's first word was "Data"
  • Is GUID good?

    A GUID is a globally unique identifier for a database.  There is much interest lately in using the GUID...

    0
    Steve Hoberman's first word was "Data"
  • Swimming in Rough Water

    I haven’t opened my bank statements since September, my favorite haunts are going out of business, and budgets have...

    0
    Steve Hoberman's first word was "Data"
  • Recycle, Reduce, Reuse

    The model below is an example of an Event and Event Line concept, a familiar structure in many of...

    0
    Steve Hoberman's first word was "Data"