Entity Relationship Diagram (ERD) Tutorial

Entity Relationship Diagram (ERD) Tutorial - Part 1

Рет қаралды 362,812

Күн бұрын

Learn how to create an Entity Relationship Diagram in this tutorial. We provide a basic overview of ERDs and then gives step-by-step training on how to make an ER diagram with correct cardinality.
Entity Relationship Diagrams are comprised of 3 main categories: entities, attributes, and relationships. Entities are objects or concepts that are associated with important data-like a customer, order, or product. Attributes represent properties or traits of an entity, such as a customer’s phone number or home address. Relationships demonstrate the link between entities.
Another main aspect of of ERD's is cardinality, which further defines the relationship between entities in a numerical way. Certain symbols signify the minimum and maximum relationship between different entities.
--
00:00 Intro
0:25 What's an ERD?
1:05 How do we make an ERD?
1:25 Entities
1:54 Attributes
2:17 Relationships
2:47 Cardinalities
3:15 ERD examples
5:20 Putting it all together
--
Learn more at: training.lucid.co
Sign up for free at: www.lucid.co
Follow us:
Facebook: / lucidsoftware
Twitter: / lucidsoftware
Instagram: / lucidsoftware
LinkedIn: / lucidsoftware

Пікірлер: 92

@lukeobot6796 5 ай бұрын

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

@pjguitar15 4 ай бұрын

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

@kiflomberihu630 8 ай бұрын

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

@kereamahohua4516 8 ай бұрын

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

@danurarya0823 Ай бұрын

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

@luciferani8279 4 ай бұрын

You make it easier than my teacher did, thank you

@WaliSayed 9 ай бұрын

Amazing and interesting, the explanation and introduction of cardinality.

@Kingoftheelectricity5485 9 ай бұрын

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.

@mdyousufgazi4030 8 ай бұрын

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

@maximvassilev172 8 ай бұрын

Super simple and easy. Thanks !

@darkthoughtbox 27 күн бұрын

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

@mmtanp 2 ай бұрын

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

@bayandkheel4405 8 ай бұрын

Thank you so much! Interesting and clear!

@uncomaaRoxx 9 ай бұрын

nice and clear explain to understand of ERDs

@camilotello3296 2 ай бұрын

I REALLY loved this one!!! Thank you SOOOO 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!

@praveenxyz123 8 ай бұрын

That was an excellent explanation, Good one!

@StudywithmeinPakistan 2 ай бұрын

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 2 ай бұрын

Present sir

@nickygood3342 2 ай бұрын

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

@luuu_na35 6 ай бұрын

It is easier than I thought, thanks!

@hamzahassan436 5 ай бұрын

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

@joyariffic4217 4 ай бұрын

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

@manisarma3304 Ай бұрын

what an awesome video. Simple and crisp

@seobizhub9116 6 ай бұрын

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

@smart_allen1851 4 ай бұрын

this was very helpful. just followed and subscribed.

@rezaainulzaki9651 8 ай бұрын

Excellent explanation, thank you

@havefun5519 3 ай бұрын

This video solves my confused. Thanks

@vampirekabir8356 8 ай бұрын

nice and clear explain to understand of ERDs thanks

@vm.odilbek 9 ай бұрын

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

@xiau 8 ай бұрын

Hope so😂

@cswithsaad 3 ай бұрын

absolutely marvelous. literally wow

@mirandaahearn5271 4 ай бұрын

This was great! Thank you

@christopherchennat5750 7 ай бұрын

This is great! Thanks!!

@omarshags 9 ай бұрын

This guy is the GOAT

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

@escobol 4 ай бұрын

thank you for this great tutorial

@zakyoung2374 5 ай бұрын

Great video!

@thenetworkguru3485 Ай бұрын

Better than my database instruction manual

@ahmedabdelzaher3274 2 ай бұрын

thank you man you helped me a lot

@mohammednajeb3716 6 ай бұрын

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

@joyaroha6683 8 ай бұрын

Thanks these are the best...

@MrBoczald 7 ай бұрын

Awasome! Thank you

@josephkarianjahi1467 2 ай бұрын

Thank you

@iampoip 7 ай бұрын

tysm easier to understand than my teacher tech me

@InfoLunix 7 ай бұрын

Awesome!

@minecaftlichking 2 ай бұрын

thanks

@warrenpatsi5156 4 ай бұрын

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

@DevEmpower 5 ай бұрын

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

@firey_solution 5 ай бұрын

dope video

@Kingoftheelectricity5485 9 ай бұрын

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

@marcoaureliodemesquita337 10 күн бұрын

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

@biomagician 6 ай бұрын

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 4 ай бұрын

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

@elalemanpaisa 3 ай бұрын

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

@nagababukasa2466 2 ай бұрын

Good

@wyattbarton1744 8 ай бұрын

what if the minimum is more than 1?

@niteshshrestha4971 6 ай бұрын

thankyou man im from nepal

@samirneupane7563 6 ай бұрын

me to

@patel5532 12 күн бұрын

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

@suthishofficial 3 ай бұрын

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

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

@fredrexsalac961 5 ай бұрын

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

@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

@bilalahmed4982 9 ай бұрын

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

@sohailkan17 5 ай бұрын

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 4 ай бұрын

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

@GringaDoe 3 ай бұрын

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

@user-ko3xh5zj1x 6 ай бұрын

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

@ganyrehs 4 ай бұрын

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

@Kashmiriboy. 3 ай бұрын

❤❤❤❤❤❤❤

@user-xb5ds5hh2k 5 ай бұрын

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

@mujahidansorimajid1524 7 ай бұрын

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

@KratosCY 3 ай бұрын

I wonder that too

@fleepy7985 9 ай бұрын

I WANT MORE CAUTION RAMEN!!!!!!!!!!!!!!!!!!!!!!

@michaeljohnson3383 Ай бұрын

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

@LaughingMan44 9 ай бұрын

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

@JXSeaton 6 ай бұрын

@@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 5 ай бұрын

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

@siddy2456 4 ай бұрын

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

@LaughingMan44 4 ай бұрын

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

@ewurafuaquansah_ Ай бұрын

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