Database Modeling with Microsoft Visio for Enterprise Architects / Edition 1
by Terry Halpin, Ken Evans, Pat Hallock, Bill Maclean
This book is for database designers and database administrators using Visio, which is the database component of Microsoft's Visual Studio .NET for Enterprise Architects suite, also included in MSDN subscriptions. This is the only guide to this product that tells DBAs how to get their job done. Although primarily focused on tool features, the book also provides an
… See more details belowOverview
This book is for database designers and database administrators using Visio, which is the database component of Microsoft's Visual Studio .NET for Enterprise Architects suite, also included in MSDN subscriptions. This is the only guide to this product that tells DBAs how to get their job done. Although primarily focused on tool features, the book also provides an introduction to data modeling, and includes practical advice on managing database projects. The principal author was the program manager of VEA's database modeling solutions.
· 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 Object Role Modeling (ORM) and Entity Relationship Modeling (ERM), and includes practical advice on managing database projects.
· Additional ORM models, course notes, and add-ins available online.
Product Details
- ISBN-13:
- 9781558609198
- Publisher:
- Elsevier Science
- Publication date:
- 08/01/2003
- Series:
- Morgan Kaufmann Series in Data Management Systems Series
- Edition description:
- New Edition
- Pages:
- 425
- Product dimensions:
- 0.89(w) x 7.50(h) x 9.25(d)
Table of Contents
| Foreword | ||
| Preface | ||
| Pt. 1 | Overview of Database Modeling and the Database Modeling Tool | |
| 1 | Introduction | 3 |
| 2 | Database Modeling | 19 |
| 3 | Getting Started | 31 |
| Pt. 2 | The Conceptual Modeling Solution (ORM) | |
| 4 | Object Types, Predicates, and Basic Constraints | 65 |
| 5 | ORM Constraints | 97 |
| 6 | Configuring, Manipulating, and Reusing ORM Models | 121 |
| 7 | Mapping ORM Models to Logical Database Models | 133 |
| 8 | Reverse Engineering and Importing to ORM | 165 |
| 9 | Conceptual Model Reports | 177 |
| Pt. 3 | The Logical Modeling Solution (ER and Relational) | |
| 10 | Creating a Basic Logical Database Model | 203 |
| 11 | Generating a Physical Database Schema | 231 |
| 12 | Editing Logical Models: Intermediate Aspects | 255 |
| 13 | Editing Logical Models: Advanced Aspects | 281 |
| 14 | Reverse Engineering Physical Schemas to Logical Models | 297 |
| 15 | Logical Database Model Reports | 307 |
| Pt. 4 | Managing Database Projects | |
| 16 | Change Propagation and Round-Trip Engineering | 329 |
| 17 | Other Features and Best Practices | 361 |
| Glossary and ORM Notation | 389 | |
| Further Resources | 401 | |
| Index | 411 |
Customer Reviews
Average Review: