Distributed Data Modeling Kit

This is what I use when I engage with a new employer or client who has never had data modeling rigor or direction.

First written in 1997 and updated every year to stay current. Used at small to Fortune 100 companies, across seven different industries.

This Data Modeling kit includes 105 pages of the following documents:

• Intro to Data Modeling (with links to further training and resources)
• Guiding Principles of Relational Data Modeling
• Relational Data Design Checklist (with links to detailed explanation in the Guide)
• Business Analysis for Data Design
• Physical Modeling Guide (PostgreSQL-centric)
• Data Object Naming Guide (PostgreSQL-centric)

By putting these guides and standards on a shared server area, like your company intranet, SharePoint, or Atlassian Confluence space, you lay the foundation and detailed training so that software engineers can get answers to their questions about "How do we do things here?"

Feel free to customize the checklist, Naming Guide matrix, and any recommendations to suit your style.

I have a similar set for NoSQL (Document) data design, which I have not yet published. Email info@datasherpa.blog if you are interested in that set.