Steve Hoberman’s 10 Questions to use in your Data Model Scorecard
- How do the characteristics of the model support the type of model e.g., OLTP or OLAP
- How well does the model capture the requirements?
- How complete is the model?
- How structurally sound is the model? Have you checked primary and Alternate Keys, no null values, referential integrity, check constraints, Indexes, Partitions, etc
- How well does the model leverage generic structures?
- How well does the model follow naming standards?
- How well is the model arranged for readability?
- How good are the definitions? Document the entities and each attribute, and give examples of values.
- How consistent is the model with the enterprise standards? Did you refer to the enterprise glossary for physical and logical definitions reuse?
- How well does the metadata match the data?
