Practical Data Modeling

A Step-by-Step Guide Across Industries

This workbook, Logical Modeling Workbook, builds on the foundation laid in the author’s previous book, Mastering Data Modeling: From Concepts to Practical Implementation, expanding its principles with a practical, industry-specific focus. Designed as a comprehensive guide for beginner IT professionals, this workbook provides hands-on exercises and case studies across key industries—healthcare, finance, IoT, media, and more—making it an indispensable resource for those looking to deepen their expertise in logical data modeling.

Each chapter introduces unique data modeling requirements and regulatory considerations, tailored to the nuances of each industry, covering topics like complex relationships, cardinality, and advanced modeling techniques. Structured exercises enable readers to practice real-world scenarios, from constructing conceptual models to defining key relationships and entity attributes. Readers are guided through key data modeling constructs, including parties, products, locations, and transactions, which are presented consistently to promote an intuitive understanding of data structures. The workbook also includes detailed breakdowns of identifying and non-identifying relationships, normalization strategies, and the use of surrogate and composite keys to ensure data integrity.

With step-by-step diagrams and industry case studies, Logical Modeling Workbook provides readers with the skills needed to confidently design and refine logical data models that meet today’s business demands across sectors. Whether you're building foundational skills or extending prior knowledge, this workbook is a vital resource for taking your data modeling skills from concept to applied practice in any industry.

We need your consent to load the translations

We use a third-party service to translate the website content that may collect data about your activity. Please review the details in the privacy policy and accept the service to view the translations.