Entity Relationship Diagram (ERD) Tutorial and EXAMPLE
Vložit
- čas přidán 19. 12. 2022
- 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
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
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.
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!
I need this kind of tutorial in the database, easy to understand and very comprehensive I'm leaving 10/10, thank you
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!
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.
You are most welcome! Glad I was able to give you a new outlook on the technique.
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.
Excellent! Happy to provide the insight! I hope it makes your next ERD more effective!
Yep. Determining the entities was stuff for me too. Now I know how 😃.
Man this is a great explanation, thanks a lot for your content
Glad to be of service!
Man that great explanation, thanks a lot for your content
You are very welcome! I'm glad you are finding the information valuable. Cheers!
This is a great explanation!! thank you!
You're very welcome! Glad to share the info. Also, be sure to check out the other tutorials like this as well! Cheers!
Good presentation and effective explanation. Thanks ! Asst. due.
You are very welcome! I'm glad I was able to present the information in a way that resonated with you.
Thank you for this very useful video!
You're very welcome! Glad you found the information useful.
This video is amazing!
Thank you so much for that feedback! I hope you gained a lot from the video.
Well done and easy to understand.
Thanks for the feedback! Much appreciated!
thank you for this clear explanation.
My pleasure! I'm glad I was able to clarify the concept for you.
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?
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!
Thanks for the great explanation! I have a question - why didn't you add relatinoship between BOOK and CHECKOUT entities?
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!
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?
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.
Thank you :) ❤
You are very welcome! Thank you so much for watching!
great bro
Thanks for the feedback and for watching!
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!
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. 😀
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
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.
Best tutorial
Thank you so much for those kind words. I'm glad you enjoyed the content!
Good work
Hi, Cindy! I appreciate the feedback. Thanks for watching!
Should you link book with check out? Since youre pulling the book id as a fk? Doesnt it need a direct link?
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.
could you please make some videos about writing user stories in agile with some examples
Hi Riza! You're in luck! Check out the following video on User Stories in Agile: czcams.com/video/q26147zlcMU/video.html
Let me know if this helps!
@@thebadoc thank you so much
@@rizabhandari545 You are very welcome! I hope it helps!
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
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.
i have prepare a erd for airline
Wow ...that sounds interesting! I hope the video provides some guidance to you. Let me know how it goes!
what about erd using crossfoot
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!
2/5/2024
Thank you for stopping by and watching the content!
I wasn't expecting that accent 😂😂😂
Ha! I've heard that before. Curious what type of accent you were expecting.
What the hell is sensco?
Ha! Should be "sensical" 😁
calm down it looks like you're about to pop out of the screen when the video begins
Ha! I am... I'm popping out to grab your attention! Thanks for watching.
@@thebadoc nice one🤣🤣