Table of content
|
Database Modeling with Microsoft Visio for Enterprise Architects Authors: Halpin T., Evans K., Hallock P. Published year: 2002 Pages: 1/150 |
 |
- 1
- 2
- Table of Contents
- Table of Contents
- BackCover
- Database Modeling with Microsoft Visio for Enterprise Architects
- Foreword
- Preface
- 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.2 Designing Databases at the Logical Level
- 2.3 Designing Databases at the Conceptual Level
- 2.4 The Database Life Cycle
- Chapter 3: Getting Started
- 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.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 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.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 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.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.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)
- Chapter 10: Creating a Basic Logical Database Model
- 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.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
- Chapter 12: Editing Logical Models - Intermediate Aspects
- 1
- 2
|
Database Modeling with Microsoft Visio for Enterprise Architects Authors: Halpin T., Evans K., Hallock P. Published year: 2002 Pages: 1/150 |
|