Entity Relationship Diagram (ERD) Tutorial and EXAMPLE
ฝัง
- เผยแพร่เมื่อ 30 ก.ย. 2024
- 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-a...
For Business Analysis TEMPLATES, check out our BA Templates and Elicitation Questions Package here: the-business-a...
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!
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 😃.
Honestly bro, that haircut is doing you dirty. I suggest trying out a new hairstyle or do videos with a fresh cut. Anyways nice vid.
Ha! Thanks for the unsolicited advice. Glad it didn't distract you from understanding the content.
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 wasn't expecting that accent 😂😂😂
Ha! I've heard that before. Curious what type of accent you were expecting.
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.
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!
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.
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!
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.
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.
2/5/2024
Thank you for stopping by and watching the content!
this was so hard to understand, I've been studying database for a few months now and found erd confusing so went to watch some video. This one just used such a hard way of explaining stuff and the concepts and everythign just made it so hard to focus and udnerstand.
Thanks for the feedback. I'll take it into consideration though it's counter to the typical response. Just curious if you can provide an example of one of the areas you found hard to follow?
This video is amazing!
Thank you so much for that feedback! I hope you gained a lot from the video.
Man this is a great explanation, thanks a lot for your content
Glad to be of service!
This tutorial does a great job of explaining ERD fundamentals! Good work. Btw, what are some common mistakes to avoid when creating an ERD? Thanks!
Thank you and you're welcome. A common mistake is overcomplicating the diagram by adding too much detail that can make the ERD difficult to read and understand. It's important to focus on the key elements needed to convey the relationships and structure of the data.
@@thebadoc Thanks for answering!
great bro
Thanks for the feedback and for watching!
thank you for this clear explanation.
My pleasure! I'm glad I was able to clarify the concept for you.
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: th-cam.com/video/q26147zlcMU/w-d-xo.html
Let me know if this helps!
@@thebadoc thank you so much
@@rizabhandari545 You are very welcome! I hope it helps!
Thank you for this very useful video!
You're very welcome! Glad you found the information useful.
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!
Martin Brenda White Sharon Hernandez Matthew
Thanks for watching!
This was such a clear and informative discussion of ERDs! You made everything so easy to understand, especially with the example at the end. I feel confident enough to start creating my own ERD now. Thanks for making these concepts so understandable, Dr. White!
Excellent! I'm so had to hear that you are now confident enough to attempt designing an ERD. Let me know how it goes.
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!
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!
What the hell is sensco?
Ha! Should be "sensical" 😁
Thank you :) ❤
You are very welcome! Thank you so much for watching!
Man that great explanation, thanks a lot for your content
You are very welcome! I'm glad you are finding the information valuable. Cheers!
Best tutorial
Thank you so much for those kind words. I'm glad you enjoyed the content!
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.
Well done and easy to understand.
Thanks for the feedback! Much appreciated!
Good work
Hi, Cindy! I appreciate the feedback. Thanks for watching!
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🤣🤣