I've worked on thousands of databases, yet I watched both parts with laser focus. The quality of this content is simply incredible. I wish I had access to that when I started out.
The fact it can convert the diagram to code to create the tables! And to be able to do it in reverse from database to diagram! That is awesome and such a big time saver🙏🏾 thank you 😊
Please make more "lucid explains the internet" videos. Such as the snek and doggo videos. These are still being shared around social media to this day.
Nice job, Bear! Super clear. I would suggest, however, that you replace the Shipment entity discussion (and that unexplained dashed line to it) with an entity that is the bridge table between what you already show: order and product. Many naming standards call for the name of that entity to be a conjunction of the two parents - Order Product. I think it would flow a little better through those sections of the video. Also, in my experience, lining up the ends of relationship lines with the attributes they propagate to and from does not scale. It will make it much harder to arrange lines neatly on a larger diagram. Also, when there are multiple relationships propagating a primary key, the parent cardinality/optionality symbols will overlap and obscure distinctions between those that are mandatory and those that are optional.
a great explanation, as always. one thing is missing for me - the relationship between entities(other than the quantitative you mentioned), and dependant entities and their notation. thanks alot!
THANK YOU SO MUCH! I always used the export button in the right panel (it is much more prominent) and I found it so annoying to have to export all tables one by one.
Best animation on the topic. I will recommend it to my students in Pakistan. Can you tell me the software in which you make these animations . They are so cool.
Is there any example of that csv file structure? I dont want to install DB in order to be able to import structure to Lucid. I have prepared the structures in excel. Why is it not possible just simly CTRL+C in my excel and CTRL+V in the entity from ERD in lucid... Can I do that? If not why? Is there some detailed guíde how to import structures to ERD in Lucid, because I can not find any...
Hello, and thank you for the great video! Where should I store the meaning of each column? Is it possible to add a 4th column to each table in a second toggable layer? Or should I store the column meanings in a different document in Lucidchart? Or in a different software altogether? Thanks for your insight!
@@jeanlaughton1215 And then how do you store buying N of the same product or product_1 and product_2 in the order table? I think the suggestion stands. We need a way to store info about products in the order. Usually you go with more columns (if you have a fixed limit) or a junction table.
question, for the composite key section, why don't we just add "customer_ID" as a foreign key? it can make it easier to identify the order like in the example of having 2 different items being shipped as two different packages? i am just asking to make sure if my idea is valid. trying to learn and get better at databases here.
I imported an existing SQL Server tables into the ER diagram using TSV export. CSV export is not doing the relationships, so did TSV. Great, it works! a) I placed each entity by clicking. Is there a way to add multiple tables at a single shot? (like ctrl select) b) I have over 80 tables and once placed very hard to find an entity. Is there a way to search the entity on the canvas/diagram? I see shapes pane and by clicking the name, it places one more entity in the canvas, which is not what I am looking for... c) Any techniques for senior data modelers? TIA
So, could only be exported SQL database, how about no SQL database? though it's not a relationship database, however, actually ERD is convenient for get idea what the database structure.
I am student of BSCS so, I have to make a project assignment "Design Document" on "Online mobile showroom app" Can any body help me to make ERD?.................I tried myself but I am confused to draw relationship between entities..
When you sign up for door dash you will be a customer for them but you haven't ordered anything from doordash so you have zero orders whereas your friend may have ordered 5 orders so 0 to many is possible it depends on business requirement
you guys should go back to your advertising from 4 years ago. it was kind of sad to discover this gem of a channel with the old ads, and then look and see that it's just a generic corporate channel now :( where snek?
I've worked on thousands of databases, yet I watched both parts with laser focus. The quality of this content is simply incredible. I wish I had access to that when I started out.
I'm starting out now, technically I'm making my second database, but my first only needed one table, my next one, it won't be so simple. Love youtube!
@@DBSQ-wb3ht That's the way to go man, keep it up.
Best explanation of ERDs on the internet! Thank you! 🙌
The fact it can convert the diagram to code to create the tables! And to be able to do it in reverse from database to diagram! That is awesome and such a big time saver🙏🏾 thank you 😊
The CSV to ER diagram functionality in Lucid Chart is huge! Such a simple yet useful idea.
The lecture , the video editing, is a whole another level work. thanks bear
Please make more "lucid explains the internet" videos. Such as the snek and doggo videos. These are still being shared around social media to this day.
besides the top quatity app and amazing explanation about ERD''s. This guy is a masterclass on how to explain in a way that captivates the audiance
insanely good video, even helped me for my data mining course just to revisit the basics
Nice job, Bear! Super clear. I would suggest, however, that you replace the Shipment entity discussion (and that unexplained dashed line to it) with an entity that is the bridge table between what you already show: order and product. Many naming standards call for the name of that entity to be a conjunction of the two parents - Order Product. I think it would flow a little better through those sections of the video.
Also, in my experience, lining up the ends of relationship lines with the attributes they propagate to and from does not scale. It will make it much harder to arrange lines neatly on a larger diagram. Also, when there are multiple relationships propagating a primary key, the parent cardinality/optionality symbols will overlap and obscure distinctions between those that are mandatory and those that are optional.
what a flippin legend this guy is!!
I like this guy. He explains everything really well and he is a big dude named Bear. As a fellow big dude i appreciate his name lol.
Bear by name, bear by nature!
Make a full course It will be easy to follow in a structured way
If you do any requests/suggestions: may I suggest more sneke videos?
We need more charts!!! We miss the charts :(
a great explanation, as always. one thing is missing for me - the relationship between entities(other than the quantitative you mentioned), and dependant entities and their notation. thanks alot!
Just great!
easy to understand. thanks
You got a new subscriber with this video. Kudos to you!
Bro uve explained it much better than my teacher
THANK YOU SO MUCH!
I always used the export button in the right panel (it is much more prominent) and I found it so annoying to have to export all tables one by one.
that was 900 pages of book summarized, thanks a lot
Loved this explanation. Super clear
You save my day, thanks man 🎉
Great explanation, thank you!
this is really helpful. Keep up the good work
yoooooooooooo you guys are lit damn!!!!!! You are a blessing to the universe.
Please make the internet names ads again
best explanation
what a great piece of software it is. thanks very much sir
Best animation on the topic. I will recommend it to my students in Pakistan. Can you tell me the software in which you make these animations . They are so cool.
Thank you, this is great content
Such a boss. Great tutorial man
Is there any example of that csv file structure? I dont want to install DB in order to be able to import structure to Lucid. I have prepared the structures in excel. Why is it not possible just simly CTRL+C in my excel and CTRL+V in the entity from ERD in lucid... Can I do that? If not why? Is there some detailed guíde how to import structures to ERD in Lucid, because I can not find any...
Yes that would be great to know.. save my poor fingers..
thanks to my man Bear for providing us this valuable information
Amazing Explanation ❣
this was really helpful thank you
Hello, can you provide HLD and LLD in lucidchart?
Hello, and thank you for the great video! Where should I store the meaning of each column? Is it possible to add a 4th column to each table in a second toggable layer? Or should I store the column meanings in a different document in Lucidchart? Or in a different software altogether? Thanks for your insight!
Thank you for your explanation! how about alternate key and candidate key??
Thanks! very clear tutorial
We need a 3rd part about normalization 🥹🥹
We still need a bridge table for order and product, right?
The order table should be the bridging table for customer table and product table.
@@jeanlaughton1215 And then how do you store buying N of the same product or product_1 and product_2 in the order table?
I think the suggestion stands. We need a way to store info about products in the order.
Usually you go with more columns (if you have a fixed limit) or a junction table.
Thank you so much.
question, for the composite key section, why don't we just add "customer_ID" as a foreign key? it can make it easier to identify the order like in the example of having 2 different items being shipped as two different packages? i am just asking to make sure if my idea is valid. trying to learn and get better at databases here.
What happens if you only know customer name.. you need a composite key to bind the two entities.
I loved this!!!
I imported an existing SQL Server tables into the ER diagram using TSV export. CSV export is not doing the relationships, so did TSV. Great, it works!
a) I placed each entity by clicking. Is there a way to add multiple tables at a single shot? (like ctrl select)
b) I have over 80 tables and once placed very hard to find an entity. Is there a way to search the entity on the canvas/diagram?
I see shapes pane and by clicking the name, it places one more entity in the canvas, which is not what I am looking for...
c) Any techniques for senior data modelers? TIA
thank you a lot for this perfect video..
So, could only be exported SQL database, how about no SQL database? though it's not a relationship database, however, actually ERD is convenient for get idea what the database structure.
I feel like I should point out that at 4:18, Customer_ID is not 'randomly assigned', it's sequentially assigned. ;-) /pedantMode
wish wgu used this software for our SQL course
Thanks i just saw the lucid chart
Very good video my guy
So a ssn can be considered a primary key...
thank you!! next part 3
thank you jonah hill
perfect and useful
awesome! awesome! awesome!! Thank you! :)
Very helpul!!!
Anyone reading this please answer, i dont have database in csv? how should i import database
hello , can i know where did u get the excel sheet or how do i get it
u can google free excel or csv example data
@@KarMa-ws3ll that specific one is in my lectures that is why i need it the source
Thank you.
Isn't the Shipment table a bridge table too?
Hmm.. maybe the composite table for linking all the info for customers product and supplier by having the keys to all the other tables?
Love this
You are fantastic sir. better than my PSU professor. Thank you so much! Is It possible to make a video about Weak/strong relationships too?
Thanks
I am student of BSCS so, I have to make a project assignment "Design Document" on "Online mobile showroom app"
Can any body help me to make ERD?.................I tried myself but I am confused to draw relationship between entities..
your customer to order relationship is wrong , it should be one to many
Why is that?
When you sign up for door dash you will be a customer for them but you haven't ordered anything from doordash so you have zero orders whereas your friend may have ordered 5 orders so 0 to many is possible it depends on business requirement
But an order isn't generated unless there is at least one order...
Which tool is he using
Lucid
great explanation, I feel composite primary key concept is total waste, instead we can create a primary key and keep it very simple.
4:00 insta username can be changed?
Thats mean insta dont use your username as an primary key dude
how do if it is an embedded documents.. like comment collection in post
TYSM!
i miss those animal chart stuff...
I did'nt get the bridge table
Order table bridges customer table and product table. You have to separate the many to many relationship or you can't link the two..
Мне кажется, это не для новичков: вроде прикольно, но что делать если есть только 100$? Как их приумножить?
you guys should go back to your advertising from 4 years ago. it was kind of sad to discover this gem of a channel with the old ads, and then look and see that it's just a generic corporate channel now :(
where snek?
i miss the sneks
Please fix this video to include the correct relationships. order to product is a many to one relationship.
Also the customer id is auto-incrementing NOT random
Wrong.. an order can have one or many products on it and the product can be on one or many orders!!!
I miss your funny videos.
Explain panda chikens
So you started turning off comments? What is up with this train wreck of public engagement?
🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏
Someone called challenger1534 reposted your snake video.
Free Palestine 🇵🇸
???? Free Israel
@@Tocsiman free of what?!
Israel isn't invaded so as to be freed!
@@Tocsimanאני מת
@@mohammednajeb3716 need to be freed from hamas’s terror and all the other Arab countries surrounding it
weirdo
I miss
Jones Shirley Hall Mary Taylor Shirley