Creating Entity Relationship Diagrams using Draw.io

[@loebys]

an interesting explanation of ERD, step by step in a simple, slow way that makes it easy to understand, thank you Mr. Dr. May Allah increase your knowledge

[@JoyJoy-u5m]

its been 4 years but this video is still helpful!

[@kelleyannbart8348]

Thank you for this step-by-step demonstration of constructing an ERD. It is explained in a very simple way for beginners like me to understand and follow. Appreciate your tutorial.👍

[@zappertxt]

4:58 thank you! I was looking for this :)

[@danielmaserrat5060]

same lol is there a way we can copy and paste attribute names into the rows?

[@HolyApplebutter]

Thank you for this, my teacher sort of threw us this program without explaining how it works at all. Very helpful!

[@rohitxess1955]

Thank you. Very informative. I was struggling to use it. But now i'm confident enough to draw erd.

[@LePhenixGD]

AMAZING tutorial, very concise and very well explained! I will have fun now creating tables for my PostgreSQL database!

[@aaronzeka3196]

Dr Soper, your presentation are ever on point!
Thank you so much.

[@RA-do6et]

This video isn't really about an ER diagram. It is talking about a "relational model". An entity/relationship should not be talking about primary key or a combination key and such relational database terms. E.g. "An employee works for a department" - there are two entities "Employee" and "Department" and the relationship is "works". So you should pick the 'entity' icon on the left (rectangle), and the relationship icon on the left (diamond shaped). Then you draw the cardinalities (one-one, one-many.. etc). Between the rectangles (entities) and the relatioship (diamond), you draw the cardinality lines (one, many, etc).

[@quanleliu8825]

This video is very helpful for me who is learning DBMS in college. Thank you for your video!

[@LGmediaGlobal]

Thank you for this. I was bumbling through it until this tutorial. What a difference!

[@fraganya]

Thank you so much. i was completely stuck. You Saved a soul from headache

[@jospintedjou276]

Thank you so much for this demonstration. You make things very easy to understand and reproduce. Thank you!

[@Gaminiheraliyawala]

Excellent clean explanation...Thank you very much Dr. Daniel

[@riyagoswami4925]

Thank you very much for this nice tutorial. Very professionally explained!

[@bunderbah]

I couldn't figure out how to add rows but now I know. Thank you for the tutorial.

[@chujekwu]

The schoupenhauer. Thank you very much, your videos has been helping me a lot..

[@bunnychan1633]

it helped me with my project tysm. Keep the good work up!

[@djamalinfo2322]

What a fantastic explanation, thanks a lot👏💯

[@rahi187]

super amazing video, cant resist to watch & like.

[@andrewwoan]

thank you so much, the hotkey CNTRL-return saves me so much time

[@andrewwoan]

enter* since im on windows but u get da point thank u

[@rafsan2773]

Hello, very helpful video and loved it, but how do you add more columns to the table to fit more attributes?

[@emilianogomez2071]

I'm really thankful with you, I needed add a new attribute!!!

[@blossomnature6257]

Thanks a lot for the tutorial. One of the best offline tools for database design well explained

[@IrynaOleksandrivnaDemydova]

Thank you so much for this quick introduction! Very useful for me, to do my first drawing!

[@samanthamccarthy9765]

thanks very much . very useful quick summary

[@kreatur_]

Very nice and beginner friendly tutorial. Well done.

[@efoyawi4834]

can you add more columns to the relationship table? or only rows?

[@tamask]

OK, and how do I create a composite PK which consists of 3 fields? Anything I try, it puts it in a different row that is divided by a horizontal line. I'm unable to put 3 PK's between two horizontal lines. Like the two PK's in the EmployeeSkill here, only I want a 3rd one in there too. How to do that??

[@Mark4Jesus]

This was very well presented! And helpful!

[@vsp2022]

Great....Software...and also nice explanation

[@chowkisanjana1337]

Thanks a bunch for the clear explanation!

[@JokerJax]

can we connect data and automatically create erd

[@myriadpro1641]

this... is... a... LIFESAVER THANK YOU!

[@AndreiGog-n4h]

Yeah, very intuitive to add a row... Thanks!

[@nessacampbell142]

@Dr. Daniel Soper, Can you please make a physical entity diagram? I am kinda confused on how the logical and physical are different

[@ABC-333]

Yes please

[@bugsqli9301]

👍

[@ismulazam7631]

thankyou sir for your bright explaination about erd

[@marylebens1307]

Thank you Dr. Soper! I'm including your video in the materials for my SQL course.

[@InnovativeBeautifulWorld]

Thank you so much. It helped me lot.

[@supritamurmu2165]

Thanku very much it was really helpful 👍😉🥀🥀❤️❤️

[@jodyw8713]

Thank you it has been really helpful for my assignment. For the lines though, why not just use "duplicate" instead of copy and paste?

[@عبداللهمحمدالقردعي]

Finally, can I save the design and copy it?

[@coreysheerer8199]

Is it possible to fill in the table names and column names via a csv or excel upload?

[@ibrahimozmen9668]

Thanks so much. it was a quick and very helpful tutorial.

[@makmo3gza]

I got an exam and it says: In this worksheet you will practise normalising data to produce an ERD from a paper-based record. So I have to do the same as you done or I need to uce access

[@anthonypaul378]

Thankyou. This is so Clear tutorial

[@garrydenewaldie7257]

thank you this is very clear and got me up and working quickly

[@gauravk5282]

Very well defined . Good Job

[@pynchia4119]

How to generate the SQL for the models?

[@yaowenzheng3096]

Very useful video, thank you for your sharing!

[@NostraDavid2]

Arrange > Insert > Advanced > CSV
Then insert your SQL statement (there is an example) and you're halfway there.

[@kamspal7643]

Thank you for the info. Easy to understand

[@ivobaar1761]

This is an amazing tutorial. Thanks a lot!

[@mthokozisimyende787]

TG for RUclips, amazing video

[@Nagaraj-yv9bt]

not able change the direction of the relation shape

[@adrianCoding]

Thank you, great tutorial

[@manishadhikari7050]

Is it entity relations or crows foot

[@bugsqli9301]

👍

[@homelander973]

Thank you for tutorial, it's really useful

[@DavidLevy-rh2os]

Hi, can you export the model to a sql script?

[@JoseGejunVanBoy]

What app is this?

[@kiddosknowledgewizbyakshit9954]

very useful video....Thanks a lot

[@crashtest1012]

This was perfect, thank you!

[@roxinnjeru5837]

HOW TO JOIN TWO LINES FROM DIFFERENT TABLES THAT POINT TO THE SAME PRIMARY KEY ON A TABLE WITH SAME CARDINALITY?

[@yaohongzhao3605]

Thank you very much for your video!

[@cerfux]

Thank you! - this was simply perfect. ¿What do you use to dim part of the screen while explaining, so we focus our attention on the non dimmed part?

[@liviasheilla3602]

thank you , this video really helped me

[@netfanely]

One Question. In the Logical Model E-R, In the table i can put of type data???

[@havelboumbidi440]

I think you add the data type in your data dictionary

[@samsmith8691]

This is not an ER diagram. It is a relational schema. ER diagrams are part of the conceptual database design and aren't related to a specific database type.

[@bugsqli9301]

Ryt

[@darkpekka1745]

hey really appreciated your sentiment analyser wanna talk a little more about can i get ur contact ?

[@orwakassab8326]

Thanks for this tutorial

[@DavidIbrahimDavidIbrahim]

Apakah bisa untuk mengatur garis sparator

[@_ifly]

how to add new line .

[@aykutyldz1538]

thank you very much for this nice tutorial

[@nelamminz1107]

Which app

[@TheCrowdel]

thanks mate you safe my life

[@md.robelahammed5137]

thanks a lot...it's helpful

[@zafariqbal92]

Excellent! Thank You!

[@miaoruibo3803]

Damn it's really helpful

[@stevenhe3462]

Good vid!

[@digigoliath]

Thank you!! Fantastic.

[@HienNguyen-cb8ud]

Many thanks Sir!

[@professionalman2591]

thank you sir

[@oliviayolosangweni2669]

So helpful, thank you so much, I

[@HansvanDam1944]

Thanks for a nice explanation of draw.io Please do not add 'music' in future videos as it is distracting a lot for hearing impaired people. If possible, remove in this one.

[@heatherstark5003]

Agree it would be better without music - very nice tutorial but I found the music distracting and annoying, entirely unnecessary.

[@bezualemfisseha2119]

Thank you very much you save me

[@estfanosekelkay8720]

Thank you!

[@lys95]

Cool!

[@sirdull0205]

thanks very much

[@oscardavidvalenciaalvarez9200]

Muchas gracias

[@ayyeyo]

Thanks man.

[@Chuquemeka]

Thank you sir.

[@umami07]

tks so much !

[@musakucuk2224]

thank you

[@dentalvideos6175]

perfect
thanks

[@ruggeddog3103]

soo GITMIND.COM OR DRAW.IO ???

[@drawioapp]

easy one ;-)

[@huytrinh3823]

thank you Sir !

[@cleidsonsantana1401]

perfect, thanks !

[@tanacing347]

Thanks!

[@josefinamagallanes8451]

is this free?

[@fikirtezewdie6708]

Very useful