UML Database Modeling Workbook

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.

Since 1994 Michael Blaha has been a consultant and trainer in conceiving, architecting, modeling, designing, and tuning databases. He has worked with dozens of organizations around the world. Blaha has authored seven U.S. patents, six books, and numerous articles. He received his doctorate from Washington University in St. Louis and is an alumnus of GE Global Research in Schenectady, New York. He has worked in many problem domains and specializes in financial applications.