UML Database Modeling Workbook

Book excerpt: With our appetites for data on the rise, it has become more important than ever to use UML (Unified Modeling Language) to capture and precisely represent all of these data requirements. Learn how to construct UML data models by working through a series of exercises and self-assessment tests. Beginners can learn the UML directly. Experienced modelers can leverage their understanding of existing database notations, as the book extensively compares the UML to traditional data modeling (Information Engineering). 1. Discover a new way of representing data requirements and communicating better with your business customers. 2. Understand what UML constructs mean and how to properly use them. 3. Learn subtleties of the UML. Become a power UML developer. 4. Practice constructing data models with the exercises. The back of the book answers every exercise. 5. Assess your mastery of the material. Each part has a multiple-choice test that can quantify your understanding. 6. Improve your ability to abstract – think about different ways of representation – as you construct data models. 7. Measure the quality of your data models. 8. Be able to create database designs (DDL code) starting from a UML data model. 9. Be able to write SQL database queries using a data model as a blueprint. 10. Know the differences among operational models, data warehouse models, enterprise models, and master models. They are all aspects of data modeling. This book is concise and to the point. You will learn by induction through reading, practice, and feedback.