Database Modeling with Microsoft® Visio for Enterprise Architects
Morgan Kaufmann, Sep 11, 2003 - Computers - 425 pages
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.
What people are saying - Write a review
We haven't found any reviews in the usual places.
The Conceptual Modeling Solution ORM
The Logical Modeling Solution ER and Relational
Managing Database Projects
Chapter 17 Other Features and Best Practices
Other editions - View all
Database Modeling with Microsoft Visio for Enterprise Architects
T. A. Halpin,Ken Evans,Pat Hallock
Limited preview - 2003
apply attributes Business Rules window changes Chapter check clause checkbox choose Database column name conceptual model context menu Country Code CountryName create data model data source database driver database model diagram Database Properties window DBMS DDL script default defined delete dialog box displayed document domain experts drawing window edit Enterprise Architects entity type example Fact Editor fact type FamilyName foreign key IDEF1X layer logical database model logical model logical schema main menu mandatory mapping Microsoft Microsoft SQL Server migrate model elements notation object type ODBC ODBC driver option ORM model ORM source model PapSmear patientNr physical data types physical name physical schema portable data types predicate primary key reference mode reference scheme relationship reverse engineer right-click ring constraint role sexCode shape shown in Figure shows specific SQL Server stencil stored procedures subtype supertype tool uniqueness constraint VEA’s verbalization