Entity Relationship Diagram (ERD) Tutorial - Part 1

Подписаться 488 тыс.

Просмотров 329 тыс.

50% 1

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

Наука

Опубликовано:

25 июн 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 85

@lukeobot6796 4 месяца назад

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

@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

@kiflomberihu630 6 месяцев назад

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

@pjguitar15 2 месяца назад

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

@kereamahohua4516 6 месяцев назад

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

@bayandkheel4405 7 месяцев назад

Thank you so much! Interesting and clear!

@maximvassilev172 6 месяцев назад

Super simple and easy. Thanks !

@thenetworkguru3485 6 дней назад

Better than my database instruction manual

@WaliSayed 7 месяцев назад

Amazing and interesting, the explanation and introduction of cardinality.

@luciferani8279 3 месяца назад

You make it easier than my teacher did, thank you

@luuu_na35 4 месяца назад

It is easier than I thought, thanks!

@mdyousufgazi4030 6 месяцев назад

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

@camilotello3296 24 дня назад

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

@mmtanp Месяц назад

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

@praveenxyz123 7 месяцев назад

That was an excellent explanation, Good one!

@hamzahassan436 4 месяца назад

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

@uncomaaRoxx 8 месяцев назад

nice and clear explain to understand of ERDs

@codzilla90 15 дней назад

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.

@omarshags 7 месяцев назад

This guy is the GOAT

@Kingoftheelectricity5485 8 месяцев назад

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.

@manisarma3304 29 минут назад

what an awesome video. Simple and crisp

@rezaainulzaki9651 7 месяцев назад

Excellent explanation, thank you

@cswithsaad Месяц назад

absolutely marvelous. literally wow

@winteriscoming4407 16 дней назад

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

@joyariffic4217 3 месяца назад

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

@nickygood3342 17 дней назад

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

@christopherchennat5750 6 месяцев назад

This is great! Thanks!!

@havefun5519 2 месяца назад

This video solves my confused. Thanks

@mirandaahearn5271 3 месяца назад

This was great! Thank you

@smart_allen1851 3 месяца назад

this was very helpful. just followed and subscribed.

@vampirekabir8356 6 месяцев назад

nice and clear explain to understand of ERDs thanks

@seobizhub9116 4 месяца назад

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

@escobol 3 месяца назад

thank you for this great tutorial

@ahmedabdelzaher3274 Месяц назад

thank you man you helped me a lot

@joyaroha6683 6 месяцев назад

Thanks these are the best...

@zakyoung2374 4 месяца назад

Great video!

@sekharv4 7 дней назад

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

@vm.odilbek 7 месяцев назад

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

@xiau 7 месяцев назад

Hope so😂

@MrBoczald 6 месяцев назад

Awasome! Thank you

@InfoLunix 5 месяцев назад

Awesome!

@mohammednajeb3716 4 месяца назад

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

@josephkarianjahi1467 20 дней назад

Thank you

@DevEmpower 3 месяца назад

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

@iampoip 6 месяцев назад

tysm easier to understand than my teacher tech me

@warrenpatsi5156 2 месяца назад

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

@minecaftlichking Месяц назад

thanks

@firey_solution 3 месяца назад

dope video

@biomagician 5 месяцев назад

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 3 месяца назад

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

@wyattbarton1744 7 месяцев назад

what if the minimum is more than 1?

@niteshshrestha4971 5 месяцев назад

thankyou man im from nepal

@samirneupane7563 4 месяца назад

me to

@sohailkan17 3 месяца назад

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 3 месяца назад

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

@elalemanpaisa 2 месяца назад

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

@fredrexsalac961 4 месяца назад

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

@Kingoftheelectricity5485 8 месяцев назад

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

@nagababukasa2466 Месяц назад

Good

@bilalahmed4982 7 месяцев назад

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

@GringaDoe Месяц назад

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

@Kashmiriboy. 2 месяца назад

❤❤❤❤❤❤❤

@suthishofficial Месяц назад

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

@user-ko3xh5zj1x 5 месяцев назад

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

@ganyrehs 3 месяца назад

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

@user-xb5ds5hh2k 3 месяца назад

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

@mujahidansorimajid1524 6 месяцев назад

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

@KratosCY 2 месяца назад

I wonder that too

@MudHut67 7 месяцев назад

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

@JXSeaton 5 месяцев назад

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