Database Modeling with Microsoft® Visio for Enterprise Architects

Foreword Preface Part 1 Overview of Database Modeling and the Database Modeling Tool 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 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 3 Getting Started 3.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) 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 5 ORM Constraints 5.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 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 7 Mapping ORM Models to Logical Database Models 7.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 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 9 Conceptual Model Reports 9.1 Conceptual Model Reports-Overview 9.2 Object Type Reports 9.3 Constraint Type Reports 9.4 Fact Type Reports 9.5 Supertype Reports 9.6 Copying Diagrams and Text Part 3 The Logical Modeling Solution (ER and Relational) 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 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 11.5 The ODBC Driver Setup Pane 12 Editing Logical Models: Intermediate Aspects 12.1 The Database Properties Dialog 12.2 Table Properties 12.3 Column Properties 12.4 Foreign Key Relationships 12.5 Category Relationships 12.6 Show Related Tables 12.7 Views 12.8 Pagination 12.9 Verbalization 12.10 Model Error Check 12.