Entity-Relationship Diagrams

Puzzled over how to make an entity-relationship diagram? This quick video shows you how.

This lecture is only one of fifty on Seventh Morning's "Fundamentals of Business Analysis" course.

Check it out here... This link discounts the course down to $99, but it's only available for the first 500 subscribers...

[seabus.]

Who else came here from the "SQL for Data Sciene" course. Week 1, additional studies.

[dayday]

If only there were more quality videos on YouTube like this! Well paced, easy to understand and well narrated.

[johnhurley]

helpful! You sir just summed up an entire chapter of my textbook in less than 9 minutes.

[janinearif]

They should just play this in my lectures at university! It would have saved them 2 hours of us all wanting to fall to sleep. Thank you for explaining this in an easier-to-understand and not-so-boring way.

[tasadem]

Completely newbie here! Although it looks very complex, analogy is very simple. Everything makes sense right now. Thank you for your time!

[Rad-ptwp]

Crazy how I found this video before following Coursera's recommendation to this video! I will binge watch the rest of this!

[Stagedrengen]

I'm late to the party on this, but a great instructional video on YouTube always deserves praise! Thanks a ton!

[TheWaveism]

THANK YOU!!!! Finally a video that makes sense and properly explains an entity-relationship diagram! Very well done!

[slothc]

Kudos on explaining an actual ER diagram instead of those confusing data model lookalikes most people choose (which are less abstract, and a lot of people prefer that, but easily lead to mistakes).

I personally prefer listing attributes separately, beneath the ER diagram, to make it cleaner since ER is mostly about relationships and because attributes aren't really crucial for the ER part.


p.s. I also hated these (on my first year), but on my fourth year when I got a serious db project, I finally understood them and started to love, well... appreciate, them.

[scimitar]

exactly what i needed to hear and see to make things simpler. thanks for everything

[lifeviz]

so much better and well-explained than my databases professor. thanks for making this video, appreciate it! :)

[NorwalkAberdeen]

LOL, yeah, Don has a good nerd laugh. Glad you like it.

[mahmoudsharshira]

OMG, I took ER Diagrams from 2 years at college and I used to hate them so much. However, I started to refresh about them because of SQL and well ah I love them now. Strange how people from different parts of the world can have the same Experience! Thank you buddy for the Great Explanation!

[sukhammittal]

The video was very simple, clear and easy to understand. Great Job!!

[NorwalkAberdeen]

@Louise cris -- Youtube won't let me reply to your comment! Grr!

In short, these diagrams are put together long before we start to worry about IDs and keys. We would start to use those concepts when creating a logical (or even physical) data model.

[gnomesonfire]

This was so useful, I'll never be the first one to say it but going around you-tube looking for technical minded videos can be a nightmare even when the videos really are there with the best of intent.

The explanations were clear and simple, each slide was nicely separated so it never felt as though there was too much going on at any one point  the voice over that was giving the explanation of the video was clear, engaged and associable *when I say this, I'm criticizing the countless videos that go on with dry, highly scripted lines that just feel abominable to listen to without breaking your own sanity(

[princessteeana]

Very clear and concise explanation, thank you!!

[baqirhusain]

amazingly intuitive and simple to follow. Thank you. You are an extraordinary teacher.

[mr.commonsense]

This is soo helpful, hoping you make your videos. Your explanation is just very easy to understand

[farukyldrm]

if I understand it correctly, in the diagram at 8:00 I thnk there is a typo in the relation "has", a course has multiple lectures (it can participate in multiple "has" reln instance)
but a lecture belongs to 1 course, (a lecture can be seen at most one reln instance in the "has" reln set). so, the connection labels 1 and n are not in the correct places, they should be replaced.