TABLE OF CONTENTS Parts 1 and 2 provided an overview of the database modeling features in Visio for Enterprise Architects, and discussed the ORM conceptual modeling solution in depth.
Part 3 focuses on the logical modeling solution. It shows how to create and edit a logical database model and how to generate a physical database schema from it. It also explains how to reverse engineer a physical database schema to a logical data model, and how to generate reports that document the logical model.
Chapter 10 shows you how to use the Database Model Diagram and ER Source Model solutions to create a logical database model directly, using either pure relational notation, or an ER-like notation such as IDEF1X. You learn how to add attributes to relation schemes, and specify primary, alternate, and foreign key constraints. You also learn the basics of managing logical models, and how to add ER source models to database projects.
Chapter 11 shows you how to generate a physical model from a logical model. You learn how to setup database drivers, choose generation options, and generate DDL scripts.
Chapter 12 provides detailed instructions about editing and managing a logical model. You learn to rename and move columns, edit foreign key and category relationships, and...
