Al Salmo Aliko .
Hello, in this post I'll discuss with you how to design good Entity Relationship Diagram ERD .
this article for:
Hello, in this post I'll discuss with you how to design good Entity Relationship Diagram ERD .
this article for:
- IT Students learning about database.
- you are having difficulties in creating ERD.
- you are developer that need help in database design.
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 Entity is some thing we want to store data about.
a relationship shows how entity is related to another entity.
types of relationship:
- One : One
- One : Many
- Many : Many
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
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
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!
ReplyDeleteThanks 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