Entity-Relationship Diagrams

Рет қаралды 654,445

10 жыл бұрын

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...
www.udemy.com/businessanalysi...

Пікірлер: 168

@dayday8421 6 жыл бұрын

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

@NorwalkAberdeen 6 жыл бұрын

David, thanks for your kind words!

@jr1152 5 жыл бұрын

@@NorwalkAberdeen make more tutorial vids please

@johnhurley8918 8 жыл бұрын

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

@NorwalkAberdeen 8 жыл бұрын

+John Hurley Awesome. Glad it's helpful!

@abdulrahmanismailali1064 Жыл бұрын

@@NorwalkAberdeen can you help me

@janinearif7850 5 жыл бұрын

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.

@TheWaveism 5 жыл бұрын

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

@Stagedrengen 3 жыл бұрын

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

@tasadem20 2 жыл бұрын

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

@lifeviz28568 2 жыл бұрын

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

@scimitar4211 7 жыл бұрын

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

@Rad-pt9wp 3 жыл бұрын

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

@anubseran4774 7 жыл бұрын

It's amazing how a clear voice spoken in neutral english can make all the difference. Given all unintelligible indian tutorials about this that I had to skip before getting to (and staying with) this one.

@benjamindemontgomery6317 6 жыл бұрын

Yes i wish there was a filter for dialects

@kriswright5112 6 жыл бұрын

here's some voice conversion software: github.com/andabi/deep-voice-conversion

@sukhammittal7630 4 жыл бұрын

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

@seabus.2003 Жыл бұрын

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

@geraldineorieoma7169 5 ай бұрын

Meee😊

@seabus.2003 5 ай бұрын

@@geraldineorieoma7169 That's nice, good luck with the studies 😊

@GagandeepSingh-sb1uk 27 күн бұрын

what you guys doing now ! I just started studying

@NorwalkAberdeen 9 жыл бұрын

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

@princessteeana8834 8 жыл бұрын

Very clear and concise explanation, thank you!!

@baqirhusain5652 Жыл бұрын

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

@vinayabeveney5201 7 жыл бұрын

Thank you so much! This was exactly what I needed!

@elianj.gonzalez3886 8 жыл бұрын

i finally understand these THANK YOU

@mahmoudsharshira1690 9 ай бұрын

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!

@mr.commonsense6645 Жыл бұрын

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

@lazaros.v8626 8 жыл бұрын

Much liked your method in actually identifying the Cardinality. Thanks : )

@NorwalkAberdeen 7 жыл бұрын

@Louise cris -- KZfaq 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.

@DeepSukhwani 8 жыл бұрын

Thats a very helpful explanation. Thanks so much!

@user-nx5rg8pl8z 4 жыл бұрын

Thank you! It was very informative and easy to understand.

@jyotijangra388 7 жыл бұрын

great tutorial man, kudos!

@bigchiefnoble6077 4 жыл бұрын

I dont even know how i made it to this video but i just learned something. Great info

@alleluiawoluba3601 2 жыл бұрын

Simple and great explanation. Thanks

@slothc 9 жыл бұрын

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.

@NorwalkAberdeen 8 жыл бұрын

+slothc Appreciation is good enough :) Regarding the attributes being listed separately, I wouldn't disagree with you. Especially because in the real world, the list of attributes can be enormous and muck up the visual model. Thanks for the kudos!

@abhishekghimire3539 9 ай бұрын

Clear and concise. Thank you sir!

@brand1974 3 ай бұрын

Great video. This explains a lot.

@gnomesonfire1 9 жыл бұрын

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(

@NorwalkAberdeen 9 жыл бұрын

Great! Glad it's helpful!

@abdelbadiakaramostefa8908 2 жыл бұрын

I want to thank you a lot for this explanation.

@hobieperez8144 3 жыл бұрын

Thank you sir, This video made me understand what my prof tried to explain.

@bharatiya804 Жыл бұрын

Thank you so much. You have made it so easy to understand.

@tarunverma4935 6 жыл бұрын

Explained in the simplest way, glad I found your video for ER diagrams.

@essas.coisas 2 жыл бұрын

Wow thanks for the easy explanation !

@danielangelomaniego1796 7 жыл бұрын

Many thanks, it helped me alot :)

@gauthamp7169 7 жыл бұрын

you saved my day ...brilliant

@Premier007 9 жыл бұрын

Sweet video hopefully it will make my pass my database exam :)

@NorwalkAberdeen 9 жыл бұрын

Good luck!

@Oz007 7 жыл бұрын

Life saving :) much thanks

@AK476056 4 жыл бұрын

Very helpful for A level, thank you

@roosman5322 8 жыл бұрын

im having trouble with the n and m what side do i use wich

@8Trails50 9 жыл бұрын

Awesome. I was pretty confused in lecture about the ER Diagram. Great video.

@NorwalkAberdeen 9 жыл бұрын

Great! Thanks for the feedback. :)

@Thezizoubear 6 жыл бұрын

Excellent, thank you!

@JayasuryanChandrasekharCMF Жыл бұрын

Simply amazing!

@mbenyane Жыл бұрын

Thank you very much sir, you really helped me on my assignment.

@AmitKumar-xn6vg 8 жыл бұрын

Great Video.... So helpful....Thanks.................Seventh Morning LLC

@chelangatjobchemorput903 5 жыл бұрын

i have followe you explanation but may you please clarify on how to list assumptions and how to write a data documentation for the ER diagram

@icpit 9 жыл бұрын

5:37 That Laugh LOOOOOL!! its a great video though, Really helped. Thumbs up

@datasciencewithshreyas1806 3 жыл бұрын

Superb video, thank you so much.

@louisecris8288 7 жыл бұрын

what about the unique identifier or primary key of each entity?

@Tanveer048 Жыл бұрын

easily understood .. thanks sir

@xdebugger123 2 жыл бұрын

Thank you sir very imformative and clearly explained the symbols

@rinavenhlovska2279 7 жыл бұрын

Thank you, dear author, you literally saved my life!

@NorwalkAberdeen 7 жыл бұрын

Ne za chto!

@dayday8421 6 жыл бұрын

OK, you have to explain as this sounds like an amazing story.... or did you just use literally incorrectly?

@osamamohamedos2033 Жыл бұрын

I spent one hour to see some one good But you are fantastic 🤩 Thx a lot it helps me ❤️

@yosin12 8 жыл бұрын

Good video, thanks.

@Imrankhan-nn5kp 7 жыл бұрын

Thank you!!

@pavelsavelev2560 Жыл бұрын

Really helpful , thank you

@wilomuyoma8412 8 жыл бұрын

Thank you!

@ejaywillie 8 жыл бұрын

This is really good, I'm surprise on the low number of videos

@circadianite 9 жыл бұрын

I got so curious from the comments I had to skip forward to hear the laugh before I could concentrate lol.

@morenomo6030 5 жыл бұрын

Me too lol

@professorposh4146 4 жыл бұрын

What about Mandatory and Optional relationships?

@honprarules 4 жыл бұрын

Anyone else here from the Coursera link? This is a great video!

@masoudghahremani7913 2 жыл бұрын

merci beacoup de votre explication claire monsieur.

@toluwabanjoko6620 2 жыл бұрын

Thank you! I got over the hate significantly after watching this video😇

@vinoddiwan5792 4 жыл бұрын

Which books should I read to gain this kind of knowledge.

@jasonkladas7827 3 жыл бұрын

Good job!

@Seftehandle Жыл бұрын

very nice video. thank you for the recomendations from learn sql from data science coursera course

@kangemanmaipmokiuah226 8 жыл бұрын

MY 9minits not wasted

@abhineshchandra6718 7 жыл бұрын

it was very good sir...thanks...

@smoothie9931 4 жыл бұрын

I know it's an old video, but does anyone know how to show a foreign key in chen notation

@haru4901 Жыл бұрын

not bad this sums up my first week in 9 minutes

@hcbros105 2 жыл бұрын

"I actually used to hate these"😂😂

@raenastra 7 жыл бұрын

What are primary and foreign keys?

@emirzmen 2 жыл бұрын

Thanks a lot

@genrevefernandez195 4 жыл бұрын

Thank you!!!

@yuvrajsingh-yn3xd 3 жыл бұрын

Which geomatric shape is used to represent entity relationship in er diargram ?????

@germiljohnsagun8452 3 жыл бұрын

4:55 still confuses me, I mean, can we just use 'm' for both sides? Cause it still means multiple, right?

@bibblybopbops441 3 жыл бұрын

I'm coming from a Maths background, so bare in mind I'm new to this and could be wrong. However, in Maths it would be convention to label them differently due to them being different sets. You could have a different number of courses and users, but still have multiple of each. Therefore we are clarifying that these numbers can be different, where as if we just had both of them as M, there could be an implication that they are the same number.

@aryaa3998 5 жыл бұрын

that soundtrack at the beginning woke me up

@farukyldrm8498 Жыл бұрын

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.

@madushanprathap9901 3 жыл бұрын

Thank You

@geraldineorieoma7169 5 ай бұрын

Thank you

@elie3423 6 жыл бұрын

Thanks !

@D7ooM442 7 жыл бұрын

you make me love them , thx bro ^_^

@NorwalkAberdeen 7 жыл бұрын

Awesome!

@sahanbakmiwewa178 9 жыл бұрын

Thanks :)

@meesie1 8 жыл бұрын

How many database tables do you need if you have an ER diagram of: user studies course? Do I only have a user and course table with their attributes, or do I need a 3rd table called study?

@jeanelbicho3 8 жыл бұрын

+meesie1 hello friend, I'm studying computer science probably just as you and what we do is we have 3 tables for an entity - relationship - entity it is a little expensive in the database however this system is used to know exactly what could be the worst scenario for our database if we use a relational system and how much memory we need to assign to the database

@NorwalkAberdeen 7 жыл бұрын

Sorry - missed your question somehow! Just like Jean said, there is a third table. In this case, it might be called UserCourseMappings or something similar. And the mapping table just contains a column for the UserId and a column for the CourseId. Together those two columns comprise a composite primary key. I believe that's the most common practice. This third table also could be used if you have attributes of the relationship itself (just make additional columns in the mappings table).

@HemanthChandra Жыл бұрын

thank you

@therealborischang 7 жыл бұрын

Chen style takes u- a lot of diagram space by having attributes in individual ovals, and relationships in diamonds instead of just plain lines.

@NorwalkAberdeen 7 жыл бұрын

That is true, and they can give the impression that the relationships are entities rather than just descriptors. Couple things to watch out for.

@ayilareese3655 5 жыл бұрын

very helpful

@devinjones1455 7 жыл бұрын

thanks brother! Plain english is VERY helpful. BTW anyone ever tell you you sound like topher grace (eric from that 70's show)!

@NorwalkAberdeen 7 жыл бұрын

Glad it's helpful! And ha, no, I've never heard that until now :)

@sayyiedmohammed1101 2 жыл бұрын

Thanks

@hikariwuff 3 жыл бұрын

Oh my LORD, my teacher taught this badly

@jiaolee6158 Жыл бұрын

thanks

@mahmoudkhalaf5162 7 жыл бұрын

thanx alot

@aleonalabran103 4 жыл бұрын

Small correction: since each course can have a varying number of lectures i.e. Kn, then under the "Lecture" entity box instead of n it should say Kn, and to the left of the "Lecture" entity box instead of n it should say (n x Kn) - since every user can watch a maximum of all the lectures in the n courses.

@temelreis381 4 жыл бұрын

"And we connect them to whatever Entity or Attribute they are an Attribute of" Uhh.. Did you mean Relationship? I'm taking notes so i wanted to get everything right..

@pratiksapkota5083 Жыл бұрын

i have an entity (staff). each of the staff members are managed by zero or one staff members, except Jane Thomas who does not have a manager. The staff members may manage zero or more staff members. Attributes for the staff are (ID, Names, Sex and Age)

@chryskou8893 9 жыл бұрын

Can you please explain the attributes, that belong to relationships?

@NorwalkAberdeen 9 жыл бұрын

Hi, it's Don Hussey, the instructor. We don't use attributes on relationships nearly as often as we do on entities. But they're the same concept -- descriptors or data elements that are attached to the relationship. One example... Look at the ERD in 7:53. See the "Watches" relationship at the top-left of the diagram? Now imagine an attribute coming out of that called "In One Sitting". And for our purposes we can assume that's a Yes/No attribute that tells whether or not the User watches the Lecture in one sitting. It's an attribute of the *relationship* because it's not an attribute of the user. Neither is it an attribute of the lecture... It's an attribute of the interaction between the two. Let me know if this doesn't make sense. They're kind of wacky and seldom used.

@chryskou8893 9 жыл бұрын

Seventh Morning LLC Thank you very much,you really helped me a lot...

@jennaprice5563 6 жыл бұрын

Thank you this is really clear!

@RizalHilman Жыл бұрын

Why use "n" when it can be represent as "m" ? N and M both mean "more than one" right?

@nadiasaud2636 Жыл бұрын

@ 2:50- wasn't that an example of many-to-one? many-to-one isn't listed among the types of cardinality. Can someone please help me understand this part better?