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

Introduction to Machine Learning

Salmo Aliko . today I'll write about Machine Learning  , it is interesting topic. I put assumption I'm talking to computer since students. first of all , many of us dreamed to make robot, auto detection for missiles and treat it automatically and many awesome dreams, but we didn't know how achieve it. let me start with the definition and mentioning some of ML -M achine L earning -  applications . What is Machine Learning?   is the ability to learn without being explicitly programmed   and if we like mentioning more formal definition it is   A computer program is said to learn from experience E with respect to some class of tasks T and performance measure P, if its performance at tasks in T, as measured by P, improves with experience E. application of ML : Computer Vision. Natural Language Processing. Game playing. Market segmentation. Medical Diagnosis.   Stock Market Analysis. Search Engines. Robo...
Post a Comment
Read more