Entity Relationship Diagram (ERD) Tutorial - Part 1

[@lukeobot6796]

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

[@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

[@-AngelLopez-]

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

[@danurarya0823]

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

[@pjguitar15]

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

[@amitbhaskar1765]

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

[@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😂

[@ranjanadissanayaka5390]

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

[@CPrime-sl9dj]

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

[@kiflomberihu630]

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

[@ccarnagee7867]

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

[@crippledpasta2167]

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

[@darkthoughtbox]

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

[@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.

[@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.😊

[@luciferani8279]

You make it easier than my teacher did, thank you

[@kereamahohua4516]

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

[@CarolineGallacher-g8w]

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

[@ecentix5018]

Thank you for this, extremely high quality tutorial.

[@warrenpatsi5156]

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

[@thenetworkguru3485]

Better than my database instruction manual

[@danieldrntss]

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

[@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

[@uncomaaRoxx]

nice and clear explain to understand of ERDs

[@havefun5519]

This video solves my confused. Thanks

[@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

[@seobizhub9116]

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

[@joyariffic4217]

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

[@camilotello3296]

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

[@Shortsbymani]

i think bro like crocs

[@manisarma3304]

what an awesome video. Simple and crisp

[@ratminurisnaini]

Cool explanations! Thankss

[@bayandkheel4405]

Thank you so much! Interesting and clear!

[@WaliSayed]

Amazing and interesting, the explanation and introduction of cardinality.

[@maximvassilev172]

Super simple and easy. Thanks !

[@nickygood3342]

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

[@mohammednajeb3716]

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

[@cswithsaad]

absolutely marvelous. literally wow

[@hamzahassan436]

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

[@luuu_na35]

It is easier than I thought, thanks!

[@smart_allen1851]

this was very helpful. just followed and subscribed.

[@ahmedabdelzaher3274]

thank you man you helped me a lot

[@omarshags]

This guy is the GOAT

[@mirandaahearn5271]

This was great! Thank you

[@ThảoPhạm-i6h]

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

[@vampirekabir8356]

nice and clear explain to understand of ERDs thanks

[@Kingoftheelectricity5485]

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

[@rezaainulzaki9651]

Excellent explanation, thank you

[@praveenxyz123]

That was an excellent explanation, Good one!

[@escobol]

thank you for this great tutorial

[@christopherchennat5750]

This is great! 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!

[@josephkarianjahi1467]

Thank you

[@joyaroha6683]

Thanks these are the best...

[@Graham_Wideman]

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

[@patel5532]

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

[@niteshshrestha4971]

thankyou man im from nepal

[@samirneupane7563]

me to

[@manish_sarswat_iiitg]

Thank you bear ❤❤

[@zakyoung2374]

Great video!

[@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.😟

[@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.

[@hazellincons7139]

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

[@iampoip]

tysm easier to understand than my teacher tech me

[@MrBoczald]

Awasome! Thank you

[@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.

[@GringaDoe]

I was like: wow just that??? Alright. Homework done

[@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

[@InfoLunix]

Awesome!

[@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.

[@marcoaureliodemesquita337]

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

[@mujahidansorimajid1524]

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

[@KratosCY]

I wonder that too

[@theascendunt9960]

True, you 'can' have as many pairs of crocs as you want. BUT you shouldn't. Not even one pair.

[@DevEmpower]

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

[@firey_solution]

dope video

[@afeworkabate810]

Will you help me to Download Lucid chart from Ethiopia Pls

[@HighlandCatz]

thanks

[@elalemanpaisa]

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

[@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.

[@nagababukasa2466]

Good

[@thechaun6631]

Just make sure not to turn one in if it’s written in pencil

[@fredrexsalac961]

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

[@michaeljohnson3383]

Number of customers, not amount. Customer is a countable noun.

[@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.

[@CarolineAldrich]

1248 McLaughlin Vista

[@suthishofficial]

Anyone explain how a product comes without any orders and many orders for same product

[@Ziddi-Heart1435]

❤

[@Kashmiriboy.]

❤❤❤❤❤❤❤

[@LincolnMeier-f8i]

Jewell Shores

[@bilalahmed4982]

Thank you you beautiful man i could kiss you right now for making this so simple

[@JosnaMonse-g5m]

Michele Brooks

[@whitebarr]

what if the minimum is more than 1?

[@DTrix66]

I came here from the FIU professor video 😂

[@sharifaHasani-z1u]

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

[@ZechariahSandy]

4368 Kristoffer Gateway

[@XenaCarter-n6u]

Shea Green

[@KarenMiller-e5j]

Tremayne Viaduct

[@JamesCarver-l5n]

Schmidt Plain

[@CarmelaIon]

998 Makenzie Heights