Table of Contents


 

 
database modeling with microsoft visio for enterprise architects
Database Modeling with Microsoft Visio for Enterprise Architects
byTerry Halpin, Ken Evans, Patrick HallockandBill MacLean ISBN:1558609199
Morgan Kaufmann Publishers 2003 (426 pages)

This text explains how to use the database modeling solution in VEA, provides an introduction to data modeling using Object-Role Modeling (ORM), offers practical advice on managing database projects, and much more.

Table of Contents
Database Modeling with Microsoft Visio for Enterprise Architects
Foreword
Preface
Part 1 - Overview of Database Modeling and the Database Modeling Tool
Chapter 1 - Introduction
Chapter 2 - Database Modeling
Chapter 3 - Getting Started
Part 2 - The Conceptual Modeling Solution (ORM)
Chapter 4 - Object Types, Predicates, and Basic Constraints
Chapter 5 - ORM Constraints
Chapter 6 - Configuring, Manipulating, and Reusing ORM Models
Chapter 7 - Mapping ORM Models to Logical Database Models
Chapter 8 - Reverse Engineering and Importing to ORM
Chapter 9 - Conceptual Model Reports
Part 3 - The Logical Modeling Solution (ER and Relational)
Chapter 10 - Creating a Basic Logical Database Model
Chapter 11 - Generating a Physical Database Schema
Chapter 12 - Editing Logical Models”Intermediate Aspects
Chapter 13 - Editing Logical Models”Advanced Aspects
Chapter 14 - Reverse Engineering Physical Schemas to Logical Models
Chapter 15 - Logical Database Model Reports
Part 4 - Managing Database Projects
Chapter 16 - Change Propagation and Round Trip Engineering
Chapter 17 - Other Features and Best Practices
Glossary and ORM Notation
Further Resources
Index
List of Figures
List of Tables


Database Modeling with Microsoft Visio for Enterprise Architects explains how to use the database modeling solution in VEA, providing information unavailable anywhere else. Although primarily focused on tool features, the book also provides an introduction to data modeling using Object-Role Modeling (ORM), a conceptual approach to data modeling that is gaining increased adoption in industry. This book also includes practical, tool- agnostic advice on managing database projects. Written by four top ORM veterans , including one of the creators of VEA, this book provides unsurpassed insight and guidance to the deep functionality of this solution.

  • Explains how to model databases with Microsoft Visio for Enterprise Architects (VEA), focusing on tool features
  • Provides a platform-independent introduction to data modeling using both ORM and Entity Relationship Modeling (ERM), and includes practical advice on managing database projects

About the Authors

Dr. Terry Halpin is a professor at Northface University and is the world s foremost authority on ORM. He has led database research teams at several companies, including Visio Corporation and Microsoft Corporation, where he worked on the conceptual and logical database modeling technology in Microsoft Visio for Enterprise Architects. His publications include over 100 technical papers and five books.

Ken Evans has taught and applied ORM in English and French for 10 years. His know-how in data and process modeling and complex systems management comes from over 30 years in industry, including international jobs with IBM, EDS, Honeywell Controls, and Plessey and clients among the Fortune 500.

Patrick Hallock, M.S., is the founder of InConcept, a consulting firm, and teaches object modeling throughout the United States. He has been in the industry for 30 years, focusing on database design, with an emphasis on ORM.

Bill MacLean, CPA, is an independent consultant and teacher who has worked with relational databases for over 15 years, and consulted in database design for the last 9. He believes that the purpose of a data model is to turn business requirements into buildable specifications.