Database modeling with Microsoft Visio for Enterprise Architects / Terry Halpin ... [et al.].

Format:

Book

Contributor:

Halpin, T. A.

Series:

The Morgan Kaufmann Series in Data Management Systems

Language:

English

Subjects (All):

Microsoft Visio.

Database design.

Database management.

Physical Description:

1 online resource (441 p.)

Edition:

1st edition

Place of Publication:

Amsterdam ; Boston : Morgan Kaufmann Publishers, c2003.

Language Note:

English

System Details:

text file

Summary:

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® Vis

Contents:

Front Cover; Database Modeling with Microsoft® Visio for Enterprise Architects; Copyright Page; Contents; Part 1: Overview of Database Modeling and the Database Modeling Tool; Chapter 1. Introduction; 1.1 Why Read This Book?; 1.2 What Can You Do with Visio for Enterprise Architects?; 1.3 What Can You Do with the Database Modeling Solution?; 1.4 How Can You Best Use This Book?; 1.5 Format Conventions; Chapter 2. Database Modeling; 2.1 Four Information Levels; 2.2 Designing Databases at the Logical level; 2.3 Designing Databases at the Conceptual Level; 2.4 The Database Life Cycle

Chapter 3. Getting Started3.1 Product Editions and Versions; 3.2 Installation; 3.3 The Visio Interface; 3.4 Using Help; 3.5 Pagination and Layers; 3.6 Simple Examples of Forward Engineering; Part 2: The Conceptual Modeling Solution (ORM); Chapter 4. Object Types, Predicates, and Basic Constraints; 4.1 Object Types; 4.2 Fact Types; 4.3 Adding Basic Constraints in the Fact Editor; 4.4 Populating Fact Types with Examples; 4.5 Saving a Model; 4.6 Verbalization and Hyphenation; 4.7 Objectifying an Association (Nesting); 4.8 Model Error Checks; 4.9 Derived Fact Types; 4.10 Data Types

Chapter 5. ORM Constraints5.1 Value Constraints; 5.2 Internal and External Uniqueness Constraints; 5.3 Simple and Disjunctive Mandatory Constraints; 5.4 Constraint Editing and Deletion; 5.5 Set-Comparison Constraints; 5.6 Subtyping; 5.7 Frequency Constraints; 5.8 Ring Constraints; 5.9 Indexes; 5.10 Constraint Layers; Chapter 6. Configuring, Manipulating, and Reusing ORM Models; 6.1 Configuring ORM Preferences; 6.2 Showing Relationships for Object Types; 6.3 Redisplaying Model Elements; 6.4 Cloning Model Elements; 6.5 Cutting and Pasting Model Elements; 6.6 Referencing Model Elements

Chapter 7. Mapping ORM Models to Logical Database Models7.1 Forward Engineering ORM Source Models; 7.2 Refining the Logical Model; 7.3 Migrating Changes back to ORM Source Models; 7.4 Controlling Logical Name Generation; 7.5 Constraint Code; 7.6 Subtype Mapping; Chapter 8. Reverse Engineering and Importing to ORM; 8.1 Reverse Engineering to ORM; 8.2 Displaying the ORM Model Graphically; 8.3 Refining the ORM Schema; 8.4 Importing VisioModeler and ERX Files; Chapter 9. Conceptual Model Reports; 9.1 Conceptual Model Reports-Overview; 9.2 Object Type Reports; 9.3 Constraint Type Reports

9.4 Fact Type Reports9.5 Supertype Reports; 9.6 Copying Diagrams and Text; Part 3: The Logical Modeling Solution (ER and Relational); Chapter 10. Creating a Basic Logical Database Model; 10.1 The Database Model Diagram Solution; 10.2 Notation Options; 10.3 Creating a Database Model Diagram; 10.4 Adding Attributes to an Entity; 10.5 Adding Basic Constraints; 10.6 Basic Model Housekeeping; 10.7 Projects and ER Source Models; Chapter 11. Generating a Physical Database Schema; 11.1 Physical Schemas and Database Drivers; 11.2 Creating a Basic DDL Script; 11.3 Database Driver Options

11.4 Generating Schemas via an ODBC Connection

Notes:

Description based upon print version of record.

Includes bibliographical references and index.

ISBN:

9786611007256

9781281007254

1281007250

9780080491035

0080491030

OCLC:

476059513