%3CLINGO-SUB%20id%3D%22lingo-sub-1422559%22%20slang%3D%22en-US%22%3EDesign%20your%20database%20using%20an%20Entity%20Relationship%20Diagram%20(ERD)%20in%20Visio%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1422559%22%20slang%3D%22en-US%22%3E%3CP%3EIn%20November%2C%20we%20released%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fvisio-blog%2Fmodel-systems-using-unified-modeling-language-uml-shapes-in%2Fba-p%2F965455%22%20target%3D%22_blank%22%20rel%3D%22noopener%22%3EUML%20diagrams%20for%20the%20Visio%20web%20app%3C%2FA%3E.%20Since%20then%2C%20many%20of%20our%20users%20have%20been%20asking%20for%20the%20inclusion%20of%20Entity%20Relationship%20Diagrams%20(ERDs)%20to%20help%20them%20model%20their%20databases.%3C%2FP%3E%0A%3CP%3EER%20diagrams%20enable%20software%20engineers%20and%20system%20analysts%20to%20model%20and%20design%20their%20databases%20and%20information%20systems.%20These%20diagrams%20provide%20deep%20insight%20into%20the%20information%20that%20needs%20to%20be%20contained%20in%20the%20database%20and%20can%20also%20be%20useful%20in%20gauging%20problems%20in%20logic%20or%20deployment%20for%20existing%20databases.%3C%2FP%3E%0A%3CP%3EToday%2C%20we%20are%20excited%20to%20announce%20that%20ER%20diagrams%20are%20now%20available%20in%20Visio%20for%20the%20Web%20and%20are%20much%20improved%20in%20Visio%20desktop.%20With%20this%20release%2C%20all%20Visio%20Plan%201%20and%20Plan%202%20users%20can%20visually%20represent%20how%20different%20entities%20relate%20to%20each%20other%20in%20a%20system%20or%20database%20by%20using%20ERD%20shapes%2C%20templates%2C%20and%20sample%20diagrams.%3C%2FP%3E%0A%3CP%3EIn%20Visio%20for%20the%20web%2C%20we%20now%20support%20two%20types%20of%20ER%20diagrams%3A%20Chen%E2%80%99s%20notation%20and%20crow%E2%80%99s%20foot%20notation.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22hospital.PNG%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F195282iAB7D787315841FD7%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22hospital.PNG%22%20alt%3D%22hospital.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CEM%3EChen%E2%80%99s%20notation%20for%20a%20hospital%20management%20system%3C%2FEM%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22inventory.PNG%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F195279i75516844F6025FB6%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22inventory.PNG%22%20alt%3D%22inventory.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CEM%3ECrow%E2%80%99s%20foot%20notation%20for%20an%20inventory%20management%20system%3C%2FEM%3E%3C%2FP%3E%0A%3CP%3E%3CEM%3E%26nbsp%3B%3C%2FEM%3E%3C%2FP%3E%0A%3CP%3ETo%20help%20you%20get%20started%20easily%2C%20we%20have%20provided%20a%20few%20starter%20diagrams%20to%20represent%20different%20scenarios%20for%20both%20Crow%E2%80%99s%20foot%20and%20Chen%E2%80%99s%20notation.%20Visit%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Foffice.live.com%2Fstart%2Fvisio.aspx%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Evisio.office.com%3C%2FA%3E%2C%20select%26nbsp%3Bthe%26nbsp%3Bpreferred%26nbsp%3Bdiagram%20template%2C%26nbsp%3Band%20start%20modeling%20your%20systems%20or%20databases.%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Farticle%2F7e44448c-9415-490b-8af1-f548f46ae90c%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EOur%26nbsp%3Bsupport%20page%3C%2FA%3E%26nbsp%3Bprovides%20even%20more%20details%20on%20how%20to%20create%20your%20ER%20diagrams.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22ERD%20Gif_2%20(1).gif%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F194927i3083D56604C483A4%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22ERD%20Gif_2%20(1).gif%22%20alt%3D%22ERD%20Gif_2%20(1).gif%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EFor%20questions%20or%20feedback%20regarding%20Visio%20ERD%20templates%20and%20other%20features%2C%20please%20email%20us%20at%20%3CA%20href%3D%22mailto%3Atellvisio%40microsoft.com%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Etellvisio%40microsoft.com%3C%2FA%3E.%20Keep%20visiting%20the%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fvisio%2Fct-p%2FVisio%22%20target%3D%22_blank%22%20rel%3D%22noopener%22%3EVisio%20Tech%20Community%3C%2FA%3E%2C%20and%20follow%20us%20on%20%3CA%20href%3D%22https%3A%2F%2Fwww.facebook.com%2FMicrosoftVisio%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EFacebook%3C%2FA%3E%20and%20%3CA%20href%3D%22https%3A%2F%2Ftwitter.com%2Fmsvisio%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3ETwitter%3C%2FA%3E%20to%20stay%20current%20on%20the%20latest%20Visio%20releases.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-1422559%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22ERD%20Gif_2%20(1).gif%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F194923iD6435309505CFE1E%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22ERD%20Gif_2%20(1).gif%22%20alt%3D%22ERD%20Gif_2%20(1).gif%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EIn%20November%2C%20we%20released%20UML%20diagrams%20for%20Visio%20Web.%20Now%2C%20we%20are%20bringing%20ERD%20shapes%20and%20functionalities%20to%20enable%20users%20to%20model%20and%20design%20their%20databases%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1494087%22%20slang%3D%22en-US%22%3ERe%3A%20Design%20your%20database%20using%20an%20Entity%20Relationship%20Diagram%20(ERD)%20in%20Visio%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1494087%22%20slang%3D%22en-US%22%3E%3CP%3EIt%20is%20a%20little%20bit%20confuse%20that%20we%20design%20a%20ER%20and%20notation%20but%20could%20not%20use%20it%20to%20deploy%20into%20SQL%20server%20DB%2C%20or%20common%20data%20service.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Microsoft

In November, we released UML diagrams for the Visio web app. Since then, many of our users have been asking for the inclusion of Entity Relationship Diagrams (ERDs) to help them model their databases.

ER diagrams enable software engineers and system analysts to model and design their databases and information systems. These diagrams provide deep insight into the information that needs to be contained in the database and can also be useful in gauging problems in logic or deployment for existing databases.

Today, we are excited to announce that ER diagrams are now available in Visio for the Web and are much improved in Visio desktop. With this release, all Visio Plan 1 and Plan 2 users can visually represent how different entities relate to each other in a system or database by using ERD shapes, templates, and sample diagrams.

In Visio for the web, we now support two types of ER diagrams: Chen’s notation and crow’s foot notation.

 

hospital.PNG

Chen’s notation for a hospital management system

 

inventory.PNG

Crow’s foot notation for an inventory management system

 

To help you get started easily, we have provided a few starter diagrams to represent different scenarios for both Crow’s foot and Chen’s notation. Visit visio.office.com, select the preferred diagram template, and start modeling your systems or databases. Our support page provides even more details on how to create your ER diagrams.

 

ERD Gif_2 (1).gif

 

For questions or feedback regarding Visio ERD templates and other features, please email us at tellvisio@microsoft.com. Keep visiting the Visio Tech Community, and follow us on Facebook and Twitter to stay current on the latest Visio releases.

 

1 Comment
Occasional Contributor

It is a little bit confuse that we design a ER and notation but could not use it to deploy into SQL server DB, or common data service.