Entity Relationship Diagram (ERD) Tutorial and EXAMPLE

Рет қаралды 42,702

The Business Analysis Doctor - IIBA Certification

Жыл бұрын

An Entity Relationship Diagram (ERD or ER Diagram) is commonly used in data modeling to represent the main data entities in an organization or system. In this video, I’ll provide a comprehensive tutorial on entity diagrams for business analysts including different notations such as Chen, UML, and Crow’s Foot. We'll also look at the main components of the diagram including entities, attributes, relationships, and cardinality. The ER Diagram example will also include primary and foreign keys. I’ll also cover the difference between conceptual, logical, and physical entity relationship diagrams followed by an example of this data model.
In general, business analysts use er diagrams to help make understanding the relationship between data items easier for business stakeholders (conceptual and logical), while also illustrating the structure of these relationships (physical ERD) in a way for the technical team to build upon.
Entity Relationship Diagrams are used to:
• Establish and communicate a consistent vocabulary
• Illustrate business rules related to a domain
• Define data requirements for an information system
• Provide details about stakeholders, objects, or concepts
• Plan and set up databases that store relational data
SUBSCRIBE for more high-value business analysis content: / @thebadoc
For IIBA CERTIFICATION TRAINING check out our courses here: the-business-analysis-doctor-...
For Business Analysis TEMPLATES, check out our BA Templates and Elicitation Questions Package here: the-business-analysis-doctor-...
For more business analysis resources, check out our website here: thebadoc.com/
Not Entity Relationship Diagram (ERD) Tutorial - Part 1, but I'm Creating Entity Relationship Diagrams, But this is an Entity Relationship Diagram (ERD) Tutorial, but with Entity-Relationship Diagrams, but with ER Diagram, but I'm showing How to draw ER diagram, but with Entity-Relationship Model, but with DBMS - Entity Relationship Diagram, but an Entity Relationship Diagram (ERD) Tutorial - Part 2, but this Database Lesson, but these are the Concept of Relationships in ER Diagram, but I'm showing How to draw ER diagram, and giving an entity relationship diagram tutorial.
#erdiagram #entityrelationshipdiagram #erd #businessanalysis #datamodeling #datamodel # #businessanalyst #dataanalysis #dataanalyst #babok #babokguide

Пікірлер: 65

@thebadoc Жыл бұрын

Be sure to SUBSCRIBE for regular BA training and tips! Also, For Business Analysis TEMPLATES that will help facilitate the requirements analysis and documentation process, check out our BA Templates and Elicitation Questions Package here: the-business-analysis-doctor-self-paced-learning.thinkific.com/courses/business-analysis-template-package

@RJFlash 3 ай бұрын

This tutorial was more helpful, straightforward, and informative than the first 5 chapters of my textbook that was assigned for Data Management course. Thank you for this incredibly helpful material.

@thebadoc 3 ай бұрын

WOW! I'm am so glad I was able to add value to your learning experience. This is so encouraging to keep creating this type of content! You might also find my tutorials on Data Flow Diagrams and Sequence Diagrams useful as well. All the best on your studies!

@user-bk6ck6ju7h 7 ай бұрын

I need this kind of tutorial in the database, easy to understand and very comprehensive I'm leaving 10/10, thank you

@thebadoc 7 ай бұрын

Thank you so much for that awesome review! I'm do glad I could present the information in a way that is easy to consume! I hope the information serves you well! Also, check out my videos on the data flow diagram and sequence diagram. You might find those helpful as well. Cheers!

@masonsingleton3037 Жыл бұрын

You explained this so well! So many people have tried to train me on this and some of the concepts never made sense until now. Thank you so much.

@thebadoc Жыл бұрын

You are most welcome! Glad I was able to give you a new outlook on the technique.

@emanuelarturorivasescobar1085 9 ай бұрын

Man this is a great explanation, thanks a lot for your content

@thebadoc 9 ай бұрын

Glad to be of service!

@e.denise1450 Жыл бұрын

This was great! Thanks for sharing the tip about the noun technique. I've always found identifying which entities to include to be a challenge.

@thebadoc Жыл бұрын

Excellent! Happy to provide the insight! I hope it makes your next ERD more effective!

@masonsingleton3037 Жыл бұрын

Yep. Determining the entities was stuff for me too. Now I know how 😃.

@erikvillar9270 9 ай бұрын

This is a great explanation!! thank you!

@thebadoc 9 ай бұрын

You're very welcome! Glad to share the info. Also, be sure to check out the other tutorials like this as well! Cheers!

@emanuelarturorivasescobar1085 9 ай бұрын

Man that great explanation, thanks a lot for your content

@thebadoc 9 ай бұрын

You are very welcome! I'm glad you are finding the information valuable. Cheers!

@user-cn3cw9lq6y 6 ай бұрын

This video is amazing!

@thebadoc 6 ай бұрын

Thank you so much for that feedback! I hope you gained a lot from the video.

@higiniofuentes2551 3 ай бұрын

Thank you for this very useful video!

@thebadoc 3 ай бұрын

You're very welcome! Glad you found the information useful.

@baruchben-david4196 2 ай бұрын

thank you for this clear explanation.

@thebadoc 2 ай бұрын

My pleasure! I'm glad I was able to clarify the concept for you.

@BobDust Жыл бұрын

Well done and easy to understand.

@thebadoc Жыл бұрын

Thanks for the feedback! Much appreciated!

@smtxtv 3 ай бұрын

Good presentation and effective explanation. Thanks ! Asst. due.

@thebadoc 3 ай бұрын

You are very welcome! I'm glad I was able to present the information in a way that resonated with you.

@shanabenjamin8945 Ай бұрын

Thank you :) ❤

@thebadoc Ай бұрын

You are very welcome! Thank you so much for watching!

@chanbella6941 4 ай бұрын

Best tutorial

@thebadoc 4 ай бұрын

Thank you so much for those kind words. I'm glad you enjoyed the content!

@விஜய்குமார் Жыл бұрын

great bro

@thebadoc Жыл бұрын

Thanks for the feedback and for watching!

@cindytutu4632 Жыл бұрын

Good work

@thebadoc Жыл бұрын

Hi, Cindy! I appreciate the feedback. Thanks for watching!

@XPORIA Жыл бұрын

Nice overview of the bad old ERD - two things. Firstly, the ERD approach scares people - so many weird words - entity, cardinality, domains, nouns, primary key, foreign key. It's simply a way of describing a system so that a coder can use it to construct a Database. Why are we still doing this? BAs DO develop an understanding of the "System Model" (Types of objects / entities and their associations to other objects in the System) e.g. "Book" -> [author] -> "Contact" - a very simple vision of a system. That's all that is needed! Software can take it from there. Secondly, by dropping the ERD and using a system model approach, it is a much easier and better way to comprehend the System at the correct level of granularity for the process being developed. Of course, as you state, the ERD is really necessary for the coder. But imagine that once you have built your system model you can build your complete system WITHOUT using a software coder. That's what NoCode is all about. Let's move away from software design methods for the last millennium!

@thebadoc Жыл бұрын

That's an interesting perspective. While I do love NoCode, unfortunately, not every organization has picked up this trend. So, in order for a BA or DA to be truly effective and versatile in any organization, they need to be adept in various methods of modeling systems. There's rarely a one size fits all approach. 😀

@XPORIA Жыл бұрын

The thing about Product Owners is that they trust us, the BA's. We talk "human". we are part of the translation from Product owner to coder. No Code suits the BA down to the ground. You should give it a go. Means we become the developer, not just the conduit, opens a whole new chapter in software development, innovation, business security and on-going management. @The Business Analysis Doctor, LLC

@thebadoc Жыл бұрын

I've actually been on a few no code projects in the past that involved building out workflows. I must admit it was liberating. But at the same time, being that close to the code takes away from the time I get to spend doing more strategic work. Which is an area I strive in. But I definitely think no code environments are great for those who prefer to be more hands on with the code while also having more autonomy.

@Itstollol 3 ай бұрын

Thanks for the great explanation! I have a question - why didn't you add relatinoship between BOOK and CHECKOUT entities?

@thebadoc 3 ай бұрын

You are very welcome! Good observation. In this example, I didn't outline a business rule or requirement that would require me to display the relationship. Now, because I used the Book ID, which is Book's primary key as a "foreign key" in the Checkout entity, I technically should have included relationship lines to show their relationship. I hope that helps!

@tg8799 10 ай бұрын

In the last slide, the Book to Renewal relationship - I understand the premise but there is no Book ID in the Renewal table or a Renewal ID in the Book table... is this correct? How can a relationship be established here if there is no connection in relation?

@thebadoc 10 ай бұрын

Good Observation. Remember, when you are referencing a primary key in a table, you are pulling in all of the attributes that fall under that primary key. So by referencing the Checkout ID in the renewal table, that will pull in the Book ID (foreign key) from the checkout table. I hope that helps!

@user-ef2qh6uy3u 10 ай бұрын

My system basically allows lecturers to upload notes and allows students to view, as well submit quizzes. Lecturers can then view the submission and upload assessment for students to view. My entities are quite unclear to me. I've got Student and Admin as my entities only, would there be any other?

@thebadoc 10 ай бұрын

Hi, Samuel! When you outline the requirements and processes that exist within the system or domain, you need to identity and extract any "noun" within those processes. Any noun that the organization wants to track and is required for the process to be completed is what you need to include in the ERD. So based on the bit of information provided the entities would likely be lecturers, lecture/lesson, student, notes, and admin if they are different from the lecturer. I hope that helps.

@BluezConcepts 9 ай бұрын

Should you link book with check out? Since youre pulling the book id as a fk? Doesnt it need a direct link?

@thebadoc 8 ай бұрын

Good question! It's not necessary to show the relationship between the foreign key attribute and the original entity, but it can be beneficial for understanding the structure of your database, especially in complex databases. Especially at the physical level.

@rizabhandari545 Жыл бұрын

could you please make some videos about writing user stories in agile with some examples

@thebadoc Жыл бұрын

Hi Riza! You're in luck! Check out the following video on User Stories in Agile: kzfaq.info/get/bejne/p5hmZJdo39LHfYk.html Let me know if this helps!

@rizabhandari545 Жыл бұрын

@@thebadoc thank you so much

@thebadoc Жыл бұрын

@@rizabhandari545 You are very welcome! I hope it helps!

@user-lk3zh1wg6y 2 ай бұрын

2/5/2024

@thebadoc 2 ай бұрын

Thank you for stopping by and watching the content!

@ludespaho5373 3 ай бұрын

i want help with an exercise that i have in the databas!Describe the type of relationship between STORE and ZONE reles ERD that reflect the relationship between the STORE and ZONE Describe the types of relationships between the WORKER and the SHOP.(each shop employs many workers,one of them manges the shop) create the ERD that reflect the relationship between STORE,ZONE and WORKER Create the rational diagram

@thebadoc 3 ай бұрын

Hi, Lude! I'd love to help you with your exercise! The best forum for this would be a coaching session. you can book a session via the calendar below and we can discuss the details further: thebadoc.com/services/ola/services/one-on-one-coaching-session Looking forward to working with you.

@aydn7246 7 ай бұрын

i have prepare a erd for airline

@thebadoc 7 ай бұрын

Wow ...that sounds interesting! I hope the video provides some guidance to you. Let me know how it goes!

@user-lh1gg8ph1g 4 ай бұрын

what about erd using crossfoot

@thebadoc 4 ай бұрын

Thanks for watching! The ERD in the example is using crow's foot notation. It's also discussed in the notation section of the lesson. I hope that helps!