Erd Database Diagram. You can save your diagram in the database it will be saved in the dbo sysdiagrams table you created earlier. Er diagrams are created based on three basic concepts.
Entity relationship diagram also known as erd er diagram or er model is a type of structural diagram for use in database design. An entity relationship diagram erd is a visual presentation of entities and relationships. You will be prompted with the diagram name.
These entities can have attributes that define its properties.
Your new sql database diagram will reflect all the objects and existing connections simplifying further analysis. Er diagram stands for entity relationship diagram also known as erd is a diagram that displays the relationship of entity sets stored in a database. An entity relationship diagram erd is a visual presentation of entities and relationships. And that s why it s called entity relationship diagram erd.
