Database Modeling with Microsoft Visio for Enterprise Architects

More About This Textbook

Overview
Product Details
Related Subjects
Meet the Author
Table of Contents

Overview

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.

Audience: Data modelers, database modelers, and DBAs working with Visual Studio .NET for Enterprise Architects and subscribers to Microsoft Developer Network (MSDN); upper division undergraduate and graduate students in Computer Science and Information Science; professional courses in database modeling, business rules, Microsoft course in Visual Studio .NET and SQL Server.

Product Details

ISBN-13: 9781558609198
Publisher: Elsevier Science
Publication date: 8/1/2003
Series: Morgan Kaufmann Series in Data Management Systems Series
Edition description: New Edition
Edition number: 1
Pages: 425
Product dimensions: 0.89 (w) x 7.50 (h) x 9.25 (d)

Meet 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.

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 Plessy 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.

Read More Show Less

	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

Be the first to write a review

( 0 )

5 Star

(0)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)

If you find inappropriate content, please report it to Barnes & Noble

Database Modeling with Microsoft Visio for Enterprise Architects / Edition 1