Labels

slider

Recent

Navigation

How to Design Entity Relationship Diagram

entity relationship diagram sql, entity relationship diagram example, entity relationship diagram
Entity Relation Diagram (ER-Diagram) is very important aspect of database designing, with the help of ER Diagram we can define Primary Keys, Foreign Keys, Unique Keys so entire relations in our schema. I have suggested key steps to design fantastic ER-Diagram.



Step 1: On very first step connect to “Object Explorer Object”, and then select Server Type, Server Name, User name & password then click on “Connect”, then you show database lists under “Databases”, then expand specific database “Appsient_Db” to design ER Model, now you will find “Database Diagrams” folder, right click and on click on very first property “New Database Diagram”.

New-Database-Diagram


Step 2: Now you will pop up next window of “Add Table”, you have to add tables from the list which are you dealing with ER Model.

Tables


















Step 3:  Now you have to set primary keys, foreign keys, unique keys etc, here you can set all tables relational entity.

ER-Model-View


Step 4: Table View:  You have to “right click” on specific database object then you will list properties, now I am highlighting important features “Standard”, now we can list “Data Type”, “Allow Nulls”, so a very extensive view of our Entity relational diagram.


Table-View-Standard


Step 5: Now we have to save the “Diagram” permanently in our database.

Table-View-Standard

Step 6: Finally you will see ER Diagram “dbo.TC-ER-Diagram” under folder “Database Diagrams”.

dbo.TC-ER-Diagram


I have provided very prestigious above 6 steps which depicts very clearly How to Design Entity Relationship Diagram, this is very important when are we going to design database to provide our database to control fully performance, cost, concurrency, scalable and flexibility.

Suggested Readings

How to Schedule Backup in SQL Server ?
How to Delete Contraints in SQL Server
Could not open a connection to SQL Server


Share

Anjan kant

Outstanding journey in Microsoft Technologies (ASP.Net, C#, SQL Programming, WPF, Silverlight, WCF etc.), client side technologies AngularJS, KnockoutJS, Javascript, Ajax Calls, Json and Hybrid apps etc. I love to devote free time in writing, blogging, social networking and adventurous life

Post A Comment:

3 comments:

  1. Thanks this info was really helpful! I used a website called Lucidchart to create my own er diagram and it was really easy to understand. If you use diagrams often you should check it out!

    ReplyDelete
  2. Very helpful! I have also learned How to Draw ERD (Entity Relationship Diagram) using Lucidchart and it is very user friendly and helpful! Give it a try!

    ReplyDelete
  3. A good tutorial. Thank you for sharing. But I prefer to download templates. So much easier. I use them for their presentations. Here's a site where I download currently http://charts.poweredtemplate.com/powerpoint-diagrams-charts/index.html.

    ReplyDelete