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!!
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.
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.
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).
@@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.
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!
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!
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
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
This tutorial is fantastic! Made much more sense than my college instructor!
exactly you are right
I love tutorials with beautiful illustrations and animations. This content is high quality!
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!!
I was so lost on ERDs prior to this video. Thank you so much for such a clear and concise explanation.
I am recommending this video to my students, because i find it useful and easy to understand. Big Thumbs up and Regards from Pakistan.
Present sir
the min and max concept to apply some relationship between entity really help to understand, thanks
This helps SO much, especially with my professor who didn't explain it well at all.
You make it easier than my teacher did, thank you
this video is perfect. it explains everything in with absolute clarity.
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.
Wayy easier to understand than my college lecture! Thank you!
This channel is always the best for learning diagrams. Thank you a lot
The confetti at the end scared me. but I loved it. thanks.
Thank you very much for such understandable tutorial! I wish my lecturer in university could understand this in such way...
Hope so😂
Thank you. I enjoyed your tutorial. You made it easy to understand. The visuals are incredible. :)
Быстро нашли новую связку, молодцы, ну а я с вами всегда в профите!
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.
Thank you very much for this clear and concise tutorial. It helped a lot.😊
Great tutorial! Thank you! This will help me cram my homework which due in 12 hours
The first video that made any sense for me! Thank you
I like this guy...He made it look very easy...
that's as clean compact and concise as it can be.. perfect!
Wow thank you!!! I just graduated from Udacity but couldn't understand the ER Diagram completely.
Thank You for your time in putting this together… it’s very helpful 👌🏽
Thank you Bear! your explanation was so clear for me as a freshly entered to this field. will definitely try the app soon!
This is super clear! Thanks for the tutorial.
my professor is good but his slides kinda more definition than actual making a diagram . and that helped me understand more . thank you
"hi my names bear" of course you are.
Thank you for this, extremely high quality tutorial.
I just subscribed today for my software structuring. Thankyou
thank you so much for this amazing video. its easy to understand and cleared my confusion regarding how to think
Better than my database instruction manual
Thanks
Your explanation was easy to understand
This was the easiest to follow video ever
This video solves my confused. Thanks
Very nice teaching video. It's easy to understand
Hope you explain component diagram, we would be so grateful ❤
Video này thực sự giúp mình nâng cao kỹ năng trading của mình.
nice and clear explain to understand of ERDs
Omggg Bear!! That's such a cute and cuddly name! I love it
This video was so helpful and cool, thank u so much!
Amazing and interesting, the explanation and introduction of cardinality.
what an awesome video. Simple and crisp
this was very helpful. just followed and subscribed.
Excellent explanation, thank you
I REALLY loved this one!!! Thank you SOOOO much
Спасибо за связку! Какие ещё биржи вы порекомендуете?
Super simple and easy. Thanks !
absolutely marvelous. literally wow
It is easier than I thought, thanks!
Wow, thank you :) YOU are amazing. I love Lucid Chart, sooooo cool.
Thank you this is really helpful
True, you 'can' have as many pairs of crocs as you want. BUT you shouldn't. Not even one pair.
Very good video thank you
Thank you so much! Interesting and clear!
thank you was a great explanation
This guy is the GOAT
Don’t waste your time here I clicked on the Indian guy’s video and it’s actually good
Thank you so much, I learned a lot from this!
thank you for this great tutorial
tysm easier to understand than my teacher tech me
3:38 if a customer has zero orders then he seizes being a customer or how does this work
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).
That was an excellent explanation, Good one!
This was great! Thank you
Cool explanations! Thankss
thank you man you helped me a lot
It was realy great,thank you
nice and clear explain to understand of ERDs
thanks
Great video!
There's no relationship between you product and order tables with the attributes you've listed.
@@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.
i noticed it too, i thought you could only connect it if there's a foreign key which could be the product_id
He would need a junction table between Order and Product “OrderProduct”. They didn’t want to go this deep I guess
@@KobeBlackMamba24 IMO it's not that deep, and makes it easier to understand
He talked about the primary and foreign keys in the part two of it
thankyou man im from nepal
me to
Now it makes sense!
This is great! Thanks!!
fantactic tutorial
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!
Thanks these are the best...
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!
Zero or many takes care of zero, one, or many.
Just make sure not to turn one in if it’s written in pencil
Awasome! Thank you
Thank you bear ❤❤
How much for an autograph from the guy who does the sneks videos
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
Thank you
dope video
i think bro like crocs
Gracias!
Nice
Awesome!
Hi. Can I use Lucid website to design entities and other diagrams and show them on my Tutorials? I create Fullstack tutorials
Didn't get the relationship between Order and Product. Why there's no product's list id attribute mentioned in the Order?
i didnt find lecture for object diagram let me know please thank you
Why do the example entities/tables show all the non-PK fields as Keys? Indexed, maybe. But Keys, almost certainly not.
I was like: wow just that??? Alright. Homework done
What's the difference between 1 and 1 and only 1?
1 and only 1 means it will always be one. 1 to 1 is the relationship between two entities.
???? Entity is a row and attribute is a column but your example was opposite. I'm confused.
what is the difference between "one" and "one and only one"
I wonder that too
Like difference between 1 and 1¹
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.
I could not do the ERD shown in the video with the free version of LucidChart software.
Good
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