Microsoft Visio ERD

1
Microsoft Visio ERD

• Why use Visio instead of Access/SQL Server?
• Latest version Visio 2003
• Database Model Diagram
• No DB vendor-specific issues during design
• E.g., connection string
• Drag-and-drop connectors
• Connector Tool
• Drag-and-drop relationship
• For self-joins
• Supports cardinality
• Many document options
• DB Options Document
• Show cardinality, data types, etc.

2
Patient ERD Example
tblPerson persisting a base class
tblPatient FK3 is a self-join
3
Student Achievement ERD Partial Solution
tblRoster is an associative table with
identifying relationship type