Skip to main content

Designing Entity Relationship Diagram (ERD)

Al Salmo Aliko .
Hello, in this post I'll discuss with you how to design good Entity Relationship Diagram ERD .
this article for:

  1. IT Students learning about database.
  2. you are having difficulties in creating ERD.
  3. you are developer that need help in database design.  
let's ask ourselves Why good database design is good ? or why we need ERD?
        when I started programming Eng / Eman Ahmed was my First teacher, she said you must write your code with pen, and now I told you good database design start with paper and pen or in technological terms start with ERD, ERD is the model which shows logical layout of your database.

let's List some advantages of good database design :
  • very low or no redundant data is stored.
  •  supporting planed or unplanned queries.
  • good design easy to maintain and modify.
  • from first glance you can understand it.
an ERD consist from Entities and relationships between them; there exist many notation in textbooks and all are right I'll use in this tutorial the most expressive and most common.

an Entity is some thing we want to store data about.
a relationship shows how entity is related to another entity.

types of relationship:
  1. One : One 
  2. One : Many
  3. Many : Many
notations :
 let's see some Examples :

see complete Example :


in the example you can see student fills Only one seat .
Student takes at least one course.
course contain at least one Student.
course is taught by Only one teacher .
teacher can Teach one or more Courses .
professor teaches zero or more sections .
section is belong to at least one course.
course has at least one section.

at the end of my post I hope you understand how Make ERD .
references:
source1  
source2

Comments

  1. UnknownJune 3, 2014 at 8:13 PM

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

    ReplyDelete
  2. UnknownJune 26, 2014 at 7:32 PM

    Thanks for the help! 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

Post a Comment

Popular posts from this blog

DevExpress C# Chart Tutorial

Hello , this blog post about Charting in DevExpress , I faced many problems I visited hundreds of pages to solve this problems , actually it was the first time I use DevExpress Charts, Work is not like school or university , in school if you don't know thing you can learn it any time you want , in work you have to do today task yesterday, I like to share my knowledge and skills with you , I hope this Post help you . // clear series on chart  chart.Series.Clear(); // clear Titles of chart chart.Titles.Clear(); // legend alignment  chart.Legend.AlignmentHorizontal = LegendAlignmentHorizontal.Center; chart.Legend.AlignmentVertical = LegendAlignmentVertical.Bottom; chart.Legend.Direction = LegendDirection.LeftToRight; // creating series // series view Type example Line DevExpress.XtraCharts.Series series = new DevExpress.XtraCharts.Series("series name ", ViewType.Line); // add title  DevExpress.XtraCharts.ChartTitle chtTitle = new DevExpress.XtraCharts.Cha
3 comments
Read more

LeetCode Problem #15. 3Sum

Problem statement  Given an array   nums   of   n   integers, are there elements   a ,   b ,   c   in   nums   such that   a   +   b   +   c   = 0? Find all unique triplets in the array which gives the sum of zero. Note: The solution set must not contain duplicate triplets. Example : Given array nums = [-1, 0, 1, 2, -1, -4], A solution set is: [ [-1, 0, 1], [-1, -1, 2] ] this problem is medium but I think it is much harder especially with the condition of non duplicate,  I'll write two solutions 
Post a Comment
Read more