Deliver to your Kindle or other device


Try it free

Sample the beginning of this book for free

Deliver to your Kindle or other device

Sorry, this item is not available in
Image not available for
Image not available

Database Modeling with Microsoft® Visio for Enterprise Architects (The Morgan Kaufmann Series in Data Management Systems) [Kindle Edition]

Terry Halpin , Ken Evans , Pat Hallock , Bill Maclean
5.0 out of 5 stars  See all reviews (1 customer review)

Print List Price: £55.99
Kindle Price: £53.19 includes VAT* & free wireless delivery via Amazon Whispernet
You Save: £2.80 (5%)
* Unlike print books, digital books are subject to VAT.

Free Kindle Reading App Anybody can read Kindle books—even without a Kindle device—with the FREE Kindle app for smartphones, tablets and computers.

To get the free app, enter your e-mail address or mobile phone number.


Amazon Price New from Used from
Kindle Edition £53.19  
Paperback £55.99  
Kindle Books Summer Sale
Kindle Summer Sale: Books from 99p
Browse over 600 titles from best-selling authors, including Neil Gaiman, John Grisham, Jeffrey Archer, Veronica Roth and Sylvia Day. >Shop now

Book Description

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 Description

About the Author

Dr. Terry Halpin is a professor at Northface University. 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.

Product details

More About the Authors

Discover books, learn about writers, and more.

Customer Reviews

4 star
3 star
2 star
1 star
5.0 out of 5 stars
5.0 out of 5 stars
Most Helpful Customer Reviews
5 of 5 people found the following review helpful
5.0 out of 5 stars A First Class Book 8 Nov. 2003
By David
This is excellent.Very often, co-authored books are a mish-mash of conflicting information which leave the reader in a state of utter confusion. This is not the case here.In this beaufifully presented and perfectly illustrated book, these four writers take you through a very complex subject in an easy to follow and logical sequence giving you the inspiration to progress your project with great confidence.This really is as good as it gets!
Comment | 
Was this review helpful to you?
Most Helpful Customer Reviews on (beta) 3.2 out of 5 stars  4 reviews
18 of 19 people found the following review helpful
5.0 out of 5 stars Well written - a pleasure to use 27 Dec. 2003
By Maria - Published on
This book allows you to make the most of the database modeling aspect of Visio for Enterprise Architects (VEA).
For me finding my way around a new design environment is always time consuming, but following along with the first few chapters made it relatively painless this time. The step-by-step sequences contain not only the usual click this / type that instructions, but often also the reason WHY things are done that way. Sometimes the instructions even anticipate where a newcomer might go wrong. Here is an example from the section that introduces the user interface: "If you unxpectedly get a screen that looks like Figure 3-12 (a screendump with the the menu, toolbar and not much else) you have accidentally hidden the database task pane and should click on View > Task Pane to return to the database menu ...".
The book is carefully organised, and you are guided from a general introduction via installation to the various modeling and reverse-engineering activities, with a nice balance of general duscussion and detailed examples. For complex models there are suggestions on using layers to help with documentation and presentations, and on how to make the most of the built-in reports.
The book shows you how to use the default settings in order to make VEA do as much work for you as possible; it then shows you where and how you can best override the defaults to fine-tune your design. Sometimes a seemingly simple change can have consequences further down the line and the book points out where you have to be careful and why. If you want to go for round-trip maintenance this book helps you to organise your models to make the process as straightforward as possible.
If you are new to Object Role Modeling (ORM) then you will find enough here to show you how powerful it is, and to start using it straight away. If you do not wish to use ORM you can stay with ER models and still be well catered for.
I found the explanation of how conflicts are resolved when you synchronise the model and the physical schema after making changes in one (or both!) of them especially helpful. Being aware of the three-way synchronisation process goes a long way to understand the information presented by the wizards.
There are many useful hints all through the book, like this one: "The physical validation page of the Generate Wizard is the most likely place for errors to occur during DDL generation. Platform specific rules, such as object name lenghth, reserved words, characters, etc, are not enforced during the modeling phase prior to DDL generation. It is thus possible for a model with no conceptual or logical errors to fail physical validation".
The index has been constructed with care, the diagrams are clean and helpful and screen shots are used where appropriate. There is also a handy section with the various ORM, Logical Model and IDEFIX diagram elements.
Best of all, the book opens flat so I can use it while I am working without the need for paperweights, bulldog clips or elbows!
4 of 4 people found the following review helpful
4.0 out of 5 stars One of a kind VEA book 28 Sept. 2005
By Lee Cichanowicz - Published on
The title is not misleading; you just have to read the whole title. :] Reading the Editorial Review/ Book Description reinforces the title, so you know what you are getting here. Then, you can view the whole Table of Contents right here on Amazon. Finally, you can search the book and read excerpts. In case all of those mislead you, this is a book about using Visio to model databases.

As far as I know, there is no other book that takes on this subject, and this one does a good job of it.

I knew how to draw ER diagrams on paper and with simple diagramming tools, but it's a big leap to getting them drawn in Visio--especially if you want Visio to properly generate a physical model in SQL Server. The book really helps bridge that gap.
5 of 11 people found the following review helpful
2.0 out of 5 stars Lacks Depth 5 Jan. 2004
By John R. Lewis - Published on
I am a huge fan of Terry Halpin, and have tried to use ORM on every one of my projects since I read one his previous books. But I have to say I was disappointed in this book.
This book provides an overview of what ORM is, and how to use Microsoft's database modeling tool to design ORM models.. But it lacks depth. I learned a few small tidbits, which I could have probably gleaned from the newsgroups had I bothered.
This book will probably make it into my box of tax donations pretty quickly.
6 of 14 people found the following review helpful
2.0 out of 5 stars Misleading Title 6 July 2004
By Robert J. Neville Jr. - Published on
Format:Paperback|Verified Purchase
The title is very misleading in that the book's main focus is not on Database Modeling but the use of Visio and reverse engineering. There are very generic references to ORM and UML.
The more appropriate title should have been "Microsoft Visio for Database Modeling".
It's a great user's manual for Microsoft Visio for Enterprise Architects.
This book in combination with Information Modeling and Relational Databases: From Conceptual Analysis to Logical Design is a great combo.
Were these reviews helpful?   Let us know
Search Customer Reviews
Only search this product's reviews

Customer Discussions

This product's forum
Discussion Replies Latest Post
No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
First post:
Prompts for sign-in

Search Customer Discussions
Search all Amazon discussions

Look for similar items by category