- February 3, 2019
Ambiguity in Definitions
Read moreI review many data models throughout the year using the Data Model Scorecard technique, and over 95% of the entity and attribute definitions reviewed lack precision. There are certain terms in a definition that, if not explained, automatically make the definition imprecise and vague. The terms...
50 - January 6, 2019
Is stability an important property for a candidate key on the logical data model?
Read moreA candidate key is an attribute (or set of attributes) that identifies an entity. A candidate key is either a primary key or an alternate key. So for example, in the following Student entity, there are two candidate keys: a primary key on Student Number and...
- December 3, 2018
Learning more about JSON
Read moreOne of my New Year’s Resolutions this year is to learn more about JSON. More specifically, how does JSON act and what are all of the JSON structures, such as nested arrays, which differ from those in our relational world? (I am also currently looking for...
- August 1, 2018
The fifth of the five killer questions: Omissions
Read moreIn the free Data Model Scorecard Validation Tool, there are five “killer” questions out of the over 150 questions that are part of the tool, that if answered improperly will automatically score the model with the lowest setting of “Poor”. If you’ve used the tool, you...
- June 25, 2018
The fourth of the five killer questions: Time
Read moreIn the free Data Model Scorecard Validation Tool, there are five “killer” questions out of the over 150 questions that are part of the tool, that if answered improperly will automatically score the model with the lowest setting of “Poor”. If you’ve used the tool, you...