Microsoft® Office Visio® 2007 Inside Out

Modeling Relational and Object-Relational Databases

Whether you’ve inherited the company’s e-commerce back end and want to document it, or you simply need to understand a legacy purchasing system, an accurate database model diagram can help. Although Visio Professional 2007 can reverse engineer a database and create a diagram based on the schema, the result is more than a series of connected shapes. Visio Professional 2007 creates a model that represents the logical and physical structure of a database, including tables or entities, columns or attributes, and relationships. Visio Professional 2007 supports notation for primary keys, foreign keys, alternate keys, and indexes, as well as referential integrity and IDEF1X cardinality constraints. ...