Entity Relationship Diagram (ERD) Tutorial – Part 1




Learn how to create an Entity Relationship Diagram in this tutorial. We provide a basic overview of ERDs and then gives step-by-step training on how to make an …

Original source


29 responses to “Entity Relationship Diagram (ERD) Tutorial – Part 1”

  1. Can you do a video on creating a complicated ERD from the actual business rules? As if a company hired you to create a database and they give you a rough over view of the entity relationships. I am a student at SUU and would appreciate the extra practice very much!

  2. شرح متكامل عن مخطط قواعد البيانات ..

    خذت فكرة عامة لاكن الفكرة الي عندي خابر ان التمثيل على المخططات يكون على شكل مستطيل للكيان و معين للعلاقة ودائرة للخواص

    هالشي ضيعيني نوعا ما لاكن جودة الشرح جدا ممتاز وسهلة تاخذ الفكرة على الماشي

    اتمنى يكون لها شرح بالعربي(دبلجة)

  3. Actually, a true ERD is not a direct 1 to 1 mapping to a table as explained here. As an example an Entity can be mapped out to more than 1 table and in fact may not even be a table. That point is missing in this simple video. However, if you want to go with the assumption that your 'entities' are going to be tables than sure this information is fine.

  4. Just a quick errata for this tutorial. A purchase is a transaction. Think of it transferring zero money to another bank account, that isn't allowed as it is a bad practice. So the correct ERD cardinality should be "one or many". To be consider a costumer you should at least have one order and the order should at least have one product.

Leave a Reply