Entity Relationship Diagram (ERD) Tutorial - Part 1

[@lukeobot6796]

This tutorial is fantastic! Made much more sense than my college instructor!

[@BeTheBestYou12]

exactly you are right

[@pjguitar15]

I love tutorials with beautiful illustrations and animations. This content is high quality!

[@sekharv4]

00:04 Learning about Entity Relationship Diagrams (ERDs) 00:50 ERDs provide a visual way to understand how information is related. 01:35 Entities are objects tracked in the database. 02:19 Entities and attributes have relationships defining interactions. 03:10 Understanding relationship and cardinality between customer and order. 03:51 ERD notation for minimum and maximum relationships 04:40 Understanding relationship cardinality in ER diagrams 05:26 Export ERD directly to database using Lucidchart

[@karlton18]

I'm taking a database course as part of a grad cert at a good university, and these videos have saved my butt. The first two videos have helped clarify the first three week of modules that I just couldn't get my head around, even though I have a solid data/ excel background. Thank you so much!!

[@StudywithmeinPakistan]

I am recommending this video to my students, because i find it useful and easy to understand. Big Thumbs up and Regards from Pakistan.

[@im.ayazkhan]

Present sir

[@IanDalton]

I was so lost on ERDs prior to this video. Thank you so much for such a clear and concise explanation.

[@warrenpatsi5156]

3:38 if a customer has zero orders then he seizes being a customer or how does this work

[@BucifalulR]

I think a good way to illustrate why a customer can have 0 orders is to consider when you create a customer account on some online shop - when doing that, you become a customer (by this, we don't mean being a customer in the usual sense, but having a customer account), but have zero orders (at that moment).

[@DanielaLopez-tf7wk]

This is so well explained!!! Understood it in 5 min whereas university chapters just confused me more. Life saver!

[@kiflomberihu630]

This channel is always the best for learning diagrams. Thank you a lot

[@danurarya0823]

the min and max concept to apply some relationship between entity really help to understand, thanks

[@darkthoughtbox]

Thank you. I enjoyed your tutorial. You made it easy to understand. The visuals are incredible. :)

[@ranjanadissanayaka5390]

this video is perfect. it explains everything in with absolute clarity.

[@luciferani8279]

You make it easier than my teacher did, thank you

[@mrd9421]

Best tutorial so far!!! Congrats and thank you!

[@JhaneilTheMomTrepreneur]

The first video that made any sense for me! Thank you

[@isaacsworld5623]

Wayy easier to understand than my college lecture! Thank you!

[@-AngelLopez-]

Быстро нашли новую связку, молодцы, ну а я с вами всегда в профите!

[@vm.odilbek]

Thank you very much for such understandable tutorial! I wish my lecturer in university could understand this in such way...

[@xiau]

Hope so😂

[@Kingoftheelectricity5485]

Wooooooo. Another lucidchart vid. I don’t even care that it isn’t animal related. You’re too iconic to not be enjoyed. Have a day as amazing as you’re content and I hope you get your old viewers back.

[@mmtanp]

Thank you very much for this clear and concise tutorial. It helped a lot.😊

[@amitbhaskar1765]

that's as clean compact and concise as it can be.. perfect!

[@kereamahohua4516]

Thank You for your time in putting this together… it’s very helpful 👌🏽

[@d_asude]

The confetti at the end scared me. but I loved it. thanks.

[@CPrime-sl9dj]

This helps SO much, especially with my professor who didn't explain it well at all.

[@crippledpasta2167]

Great tutorial! Thank you! This will help me cram my homework which due in 12 hours

[@milkcap_tarot]

This is super clear! Thanks for the tutorial.

[@codzilla90]

This has been explained to me 3 different times in 3 different ways, but today I still had the question come to mind, "wait, what's an ERD? ohhh.... right, that thing." Bear, thanks to your explanation, I believe I'm now a guy who gets what an ERD is.

[@ecentix5018]

Thank you for this, extremely high quality tutorial.

[@winteriscoming4407]

Thank you Bear! your explanation was so clear for me as a freshly entered to this field. will definitely try the app soon!

[@mdyousufgazi4030]

thank you so much for this amazing video. its easy to understand and cleared my confusion regarding how to think

[@ccarnagee7867]

I like this guy...He made it look very easy...

[@joyariffic4217]

Omggg Bear!! That's such a cute and cuddly name! I love it

[@heitornz]

This is what I pay the internet for. Thanks, Bear!

[@kaellla]

this is so helpful, thank you so much!!!

[@hamadsherazi6896]

I just subscribed today for my software structuring. Thankyou

[@CarolineGallacher-g8w]

Video này thực sự giúp mình nâng cao kỹ năng trading của mình.

[@yukimmmmm]

Very nice teaching video. It's easy to understand

[@danieldrntss]

This video was so helpful and cool, thank u so much!

[@uncomaaRoxx]

nice and clear explain to understand of ERDs

[@camilotello3296]

I REALLY loved this one!!! Thank you SOOOO much

[@havefun5519]

This video solves my confused. Thanks

[@manisarma3304]

what an awesome video. Simple and crisp

[@WaliSayed]

Amazing and interesting, the explanation and introduction of cardinality.

[@seobizhub9116]

Wow thank you!!! I just graduated from Udacity but couldn't understand the ER Diagram completely.

[@ayaan.ch3]

Thanks Your explanation was easy to understand

[@NikitaNair]

Nice tutorial :)

[@Abelteamr]

A very nice tutorial!

[@smart_allen1851]

this was very helpful. just followed and subscribed.

[@omarshags]

This guy is the GOAT

[@luuu_na35]

It is easier than I thought, thanks!

[@maximvassilev172]

Super simple and easy. Thanks !

[@nemethricsi]

When to use the "one" relation? Just one line? I cannot think about a use case. It's even - zero or more - one and only one - one or more But there is a type of just "one" Thanks!

[@thenetworkguru3485]

Better than my database instruction manual

[@bayandkheel4405]

Thank you so much! Interesting and clear!

[@patel5532]

Didn't get the relationship between Order and Product. Why there's no product's list id attribute mentioned in the Order?

[@nickygood3342]

Wow, thank you :) YOU are amazing. I love Lucid Chart, sooooo cool.

[@cswithsaad]

absolutely marvelous. literally wow

[@hamzahassan436]

Thank you so much, I learned a lot from this!

[@chrisder1814]

hello I had some ideas to do automation in a WordPress database but I don't know if these ideas are good and feasible, I would like to use tools our codes, could you help me to understand if the ideas I had are good and feasible

[@DevEmpower]

Hi. Can I use Lucid website to design entities and other diagrams and show them on my Tutorials? I create Fullstack tutorials

[@rezaainulzaki9651]

Excellent explanation, thank you

[@mohammednajeb3716]

Hope you explain component diagram, we would be so grateful ❤

[@Graham_Wideman]

Why do the example entities/tables show all the non-PK fields as Keys? Indexed, maybe. But Keys, almost certainly not.

[@zoomforlife]

my professor is good but his slides kinda more definition than actual making a diagram . and that helped me understand more . thank you

[@AwetGhebre]

i didnt find lecture for object diagram let me know please thank you

[@marcoaureliodemesquita337]

I could not do the ERD shown in the video with the free version of LucidChart software.

[@mirandaahearn5271]

This was great! Thank you

[@praveenxyz123]

That was an excellent explanation, Good one!

[@ratminurisnaini]

Cool explanations! Thankss

[@ThảoPhạm-i6h]

Спасибо за связку! Какие ещё биржи вы порекомендуете?

[@ahmedabdelzaher3274]

thank you man you helped me a lot

[@kiwi_bird09]

Thank you this is really helpful

[@escobol]

thank you for this great tutorial

[@MahdiHaeri]

Thanks so muck for clear explanation

[@praveenseetharam1924]

thank you was a great explanation

[@vampirekabir8356]

nice and clear explain to understand of ERDs thanks

[@LaughingMan44]

There's no relationship between you product and order tables with the attributes you've listed.

[@JXSeaton]

@@moy3804 the order table has no product id. That and the relationship is wrong. it is a one to many relationship. Please don't try to learn database design from this company.

[@hazellincons]

i noticed it too, i thought you could only connect it if there's a foreign key which could be the product_id

[@KobeBlackMamba24]

He would need a junction table between Order and Product “OrderProduct”. They didn’t want to go this deep I guess

[@LaughingMan44]

@@KobeBlackMamba24 IMO it's not that deep, and makes it easier to understand

[@thatlastborn]

He talked about the primary and foreign keys in the part two of it

[@CasualBiker]

Hi, can we create an ER diagram for a simple snake game created using Java? Or is the ER diagram applicable only for Database? Please suggest.

[@elalemanpaisa]

So a Product can only be sold once, we is there a quantity?

[@christopherchennat5750]

This is great! Thanks!!

[@afeworkabate810]

Will you help me to Download Lucid chart from Ethiopia Pls

[@Qetirrptif]

sir do you have a course to make such beautiful tutorial videos?? its amazing

[@sohailkan17]

Hello, is it possible to use AI to create the diagram if all I give is the table and the details of the attributes? I tried using Mermaid AI with GPT's assistance, but I am unable to see the database diagram-basically an ER diagram with columns and different types of key definitions there

[@ganyrehs]

You have to use logic and make sure relationships are correct. AI can only help explain to certain level.

[@Manolete919]

Excellent!!

[@drjones694]

Very good video thank you

[@m.azadyan]

It was realy great,thank you

[@zakyoung2374]

Great video!

[@TheBatmanNPC]

This was the easiest to follow video ever

[@fredrexsalac961]

But My table shows that the fifth table connects 4 tables to the column

[@biomagician]

Hello and thank you for this great video. For the cardinality of the relationship between customers and orders, you say that a customer can have zero or many orders, and you use the corresponding sign (a zero followed by a crow's foot). However, would it not be more correct to say that a customer can have zero, one, or many orders? Is there a sign for that? Or does the zero/crow's foot sign encompass one order, and the cardinality signs only encompass minimum and maximum? If the latter is true, then it would be more correct to say that a customer can have between zero and many orders. Thanks!

[@ganyrehs]

Zero or many takes care of zero, one, or many.

[@joyaroha6683]

Thanks these are the best...

[@WilliamDemsar-j9p]

What's the difference between 1 and 1 and only 1?

[@ganyrehs]

1 and only 1 means it will always be one. 1 to 1 is the relationship between two entities.

[@iampoip]

tysm easier to understand than my teacher tech me

[@mujahidansorimajid1524]

what is the difference between "one" and "one and only one"

[@KratosCY]

I wonder that too

[@farcomsq874]

Like difference between 1 and 1¹

[@goodman854]

???? Entity is a row and attribute is a column but your example was opposite. I'm confused.

[@adnango1990]

There's M:M Relationship between Entity (Order) and Entity (Product) and It can't be implemented in real field because Many to many relationship will create data redundancy thus cannot create table. Please show a better example.😟

[@Kingoftheelectricity5485]

How much for an autograph from the guy who does the sneks videos

[@MrBoczald]

Awasome! Thank you

[@sharifaHasani-z1u]

How can a product have no order now where is it going😢

[@whitebarr]

what if the minimum is more than 1?