Schema diagrams are available for the following sample databases for SQL Server 2005 and SQL Server 2008:
Microsoft Visio versions of these schema diagrams can be found by browsing into the Schema Diagram folder on the Source Code tab.

Last edited Aug 20, 2007 at 5:27 PM by bonniefe, version 4

Comments

enormous_penguin Sep 7, 2011 at 9:46 AM 
Correct me if I am wrong. In the file AdventureWorks2008_Conceptual.vsd(AdventureWorks2008EntityModel) there is an error with the association between BusinessEntity and BusinessContact. The problem is the multiplicity at BusinessEntity side must be "1" not "*". See the picture here: http://i52.tinypic.com/mct2mc.jpg

emerald77 Aug 11, 2011 at 12:26 PM 
In the AdventureWorks2008.vsd file (when you click on the "Page Info" link above), the Sales.CountryRegionCurrency cross-reference table (which maps ISO currency codes to a country or region) is still missing from the AdventureWorks OLTP schema diagram.

jav_mart Apr 21, 2010 at 7:13 PM 
Buenas, los diagramas no estan puestos en la pagina, por favor coloquenlos para poderlos consultar. Gracias

emerald77 Nov 26, 2008 at 7:30 PM 

The Sales.CountryRegionCurrency cross-reference table (which maps ISO currency codes to a country or region) is missing from the AdventureWorks OLTP schema diagram.