Description
Book SynopsisProvides tutelage for data modelers, business analysts and systems designers at various levels. Beginning with the basics, this book provides a grounding in theory before guiding the reader through the various stages of applied data modeling and database design. It addresses advanced subjects such as business rules, data warehousing, and others.
Trade Review"The perfect balance of theory and practice, giving the reader both the foundation and the tools to deliver high-quality data models." --Karen Lopez, Principal, InfoAdvisors, Inc. "The complete guide to data modeling for the reflective practitioner. Students like this book and so do I -- it is clear and accessible without sacrificing rigor." --Professor Graeme Shanks, School of Business Systems, Monash University, Australia "A unique, practical and comprehensive guide, providing an invaluable resource to anyone involved in data modeling from the novice to the expert data modeler." --Len Silverston, author of The Data Model Resource Book, Volumes 1 and 2. "Includes an extraordinary amount of good, useful, and well articulated information about the field." --David Hay, President, Essential Strategies, Inc. and author of Data Model Patterns "Data Modeling Essentials is a fresh look at an old topic...much more accesible and refreshing in its tone and attitude. Simsion's explanations are very clear and his examples easy to follow...This book is useful for both beginners and experienced data modelers who want a new innovative approach to the important task of documenting data requirements." - The Bridge --Barbara A. Carkenord "The book is extremely well-written. It is humorous at times, full of useful anecdotes, and follows a very logical sequence...In summary, I found Data Modeling Essentials, Third Edition, very useful for data modelers at any level of experience." --DM Review
Table of ContentsPart I: Basics 1. What is Data Modeling? 2. Basics of Good Structure 3. The Entity-Relationship Approach 4. Subtypes and Supertypes 5. Attributes and Columns 6. Primary Keys and Identity 7. Extensions and Alternatives Part II: Putting it Together 8. Organizing the Data Modeling Task 9. Understanding the Business Requirements 10. Conceptual Modeling 11. Logical Database Design 12. Physical Database Design Part III: Advanced Topics 13. Advanced Normalization 14. Modeling Business Rules 15. Time-Dependent Data 16. Modeling for Data Warehouses and Data Marts 17. Enterprise Data Models and Data Management
