Creating Entity Relationship Diagrams using Draw.io

Dr. Soper demonstrates how to create entity-relationship diagrams (ERDs) using Draw.io. Topics covered include creating entities and attributes, defining primary and foreign keys, marking attributes as required, creating and modifying relationship lines, changing cardinalities, creating weak entities, and marking relationships as non-identifying.

Пікірлер: 120

  • @rohitxess1955
    @rohitxess19554 жыл бұрын

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

  • @loebys
    @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

  • @aaronzeka3196
    @aaronzeka31962 жыл бұрын

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

  • @LGmediaGlobal
    @LGmediaGlobal2 жыл бұрын

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

  • @kelleyannbart8348
    @kelleyannbart834810 ай бұрын

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

  • @LePhenixGD
    @LePhenixGD2 жыл бұрын

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

  • @riyagoswami4925
    @riyagoswami49254 жыл бұрын

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

  • @fraganya
    @fraganya4 жыл бұрын

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

  • @chujekwu
    @chujekwu4 жыл бұрын

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

  • @jospintedjou276
    @jospintedjou2768 ай бұрын

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

  • @HolyApplebutter
    @HolyApplebutter Жыл бұрын

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

  • @Gaminiheraliyawala
    @Gaminiheraliyawala2 жыл бұрын

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

  • @kreatur_
    @kreatur_4 жыл бұрын

    Very nice and beginner friendly tutorial. Well done.

  • @bunderbah
    @bunderbah2 жыл бұрын

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

  • @user-dc7zb8pw7o
    @user-dc7zb8pw7o11 ай бұрын

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

  • @quanleliu8825
    @quanleliu88259 ай бұрын

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

  • @Mark4Jesus
    @Mark4Jesus2 жыл бұрын

    This was very well presented! And helpful!

  • @zappertxt
    @zappertxt3 жыл бұрын

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

  • @danielmaserrat5060

    @danielmaserrat5060

    3 жыл бұрын

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

  • @ivobaar1761
    @ivobaar17612 жыл бұрын

    This is an amazing tutorial. Thanks a lot!

  • @blossomnature6257
    @blossomnature6257 Жыл бұрын

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

  • @garrydenewaldie7257
    @garrydenewaldie72573 жыл бұрын

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

  • @andrewwoan
    @andrewwoan4 жыл бұрын

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

  • @andrewwoan

    @andrewwoan

    4 жыл бұрын

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

  • @crashtest1012
    @crashtest10122 жыл бұрын

    This was perfect, thank you!

  • @marylebens1307
    @marylebens13074 жыл бұрын

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

  • @myriadpro1641
    @myriadpro16415 ай бұрын

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

  • @user-nu9kp4jp5f
    @user-nu9kp4jp5f4 ай бұрын

    its been 4 years but this video is still helpful!

  • @emilianogomez2071
    @emilianogomez2071Ай бұрын

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

  • @ibrahimozmen9668
    @ibrahimozmen96682 жыл бұрын

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

  • @kamspal7643
    @kamspal76432 жыл бұрын

    Thank you for the info. Easy to understand

  • @RA-do6et
    @RA-do6et2 жыл бұрын

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

  • @liviasheilla3602
    @liviasheilla36024 жыл бұрын

    thank you , this video really helped me

  • @yaowenzheng3096
    @yaowenzheng30962 жыл бұрын

    Very useful video, thank you for your sharing!

  • @djamalinfo2322
    @djamalinfo23226 ай бұрын

    What a fantastic explanation, thanks a lot👏💯

  • @anthonypaul378
    @anthonypaul3783 жыл бұрын

    Thankyou. This is so Clear tutorial

  • @rahi187
    @rahi1872 жыл бұрын

    super amazing video, cant resist to watch & like.

  • @digigoliath
    @digigoliath4 жыл бұрын

    Thank you!! Fantastic.

  • @homelander973
    @homelander9732 жыл бұрын

    Thank you for tutorial, it's really useful

  • @yaohongzhao3605
    @yaohongzhao36052 жыл бұрын

    Thank you very much for your video!

  • @zafariqbal92
    @zafariqbal923 жыл бұрын

    Excellent! Thank You!

  • @aykutyldz1538
    @aykutyldz15384 жыл бұрын

    thank you very much for this nice tutorial

  • @user-qe9cr4uk9g
    @user-qe9cr4uk9g10 ай бұрын

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

  • @adrianCoding
    @adrianCoding2 ай бұрын

    Thank you, great tutorial

  • @gauravk5282
    @gauravk52822 жыл бұрын

    Very well defined . Good Job

  • @TheCrowdel
    @TheCrowdel4 жыл бұрын

    thanks mate you safe my life

  • @ismulazam7631
    @ismulazam76318 күн бұрын

    thankyou sir for your bright explaination about erd

  • @orwakassab8326
    @orwakassab83262 жыл бұрын

    Thanks for this tutorial

  • @vsp2022
    @vsp2022 Жыл бұрын

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

  • @efoyawi4834
    @efoyawi48343 жыл бұрын

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

  • @rafsan2773
    @rafsan277310 ай бұрын

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

  • @kiddosknowledgewizbyakshit9954
    @kiddosknowledgewizbyakshit9954 Жыл бұрын

    very useful video....Thanks a lot

  • @HienNguyen-cb8ud
    @HienNguyen-cb8ud2 жыл бұрын

    Many thanks Sir!

  • @cleidsonsantana1401
    @cleidsonsantana14014 жыл бұрын

    perfect, thanks !

  • @oliviayolosangweni2669
    @oliviayolosangweni26693 жыл бұрын

    So helpful, thank you so much, I

  • @md.robelahammed5137
    @md.robelahammed51372 жыл бұрын

    thanks a lot...it's helpful

  • @tamask
    @tamask3 жыл бұрын

    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??

  • @huytrinh3823
    @huytrinh38233 жыл бұрын

    thank you Sir !

  • @supritamurmu2165
    @supritamurmu21653 жыл бұрын

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

  • @estfanosekelkay8720
    @estfanosekelkay87202 жыл бұрын

    Thank you!

  • @coreysheerer8199
    @coreysheerer81994 жыл бұрын

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

  • @Chuquemeka
    @Chuquemeka2 жыл бұрын

    Thank you sir.

  • @professionalman2591
    @professionalman25912 жыл бұрын

    thank you sir

  • @oscardavidvalenciaalvarez9200
    @oscardavidvalenciaalvarez92002 жыл бұрын

    Muchas gracias

  • @musakucuk2224
    @musakucuk22243 жыл бұрын

    thank you

  • @mthokozisimyende787
    @mthokozisimyende787 Жыл бұрын

    TG for KZread, amazing video

  • @shanabenjamin8945
    @shanabenjamin8945Ай бұрын

    Thank you

  • @bezualemfisseha2119
    @bezualemfisseha21192 жыл бұрын

    Thank you very much you save me

  • @jodyw8713
    @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?

  • @miaoruibo3803
    @miaoruibo38032 жыл бұрын

    Damn it's really helpful

  • @minirose4763
    @minirose47634 жыл бұрын

    Thanks

  • @tanacing347
    @tanacing3472 жыл бұрын

    Thanks!

  • @umami07
    @umami07 Жыл бұрын

    tks so much !

  • @ayyeyo
    @ayyeyo2 жыл бұрын

    Thanks man.

  • @stevenhe3462
    @stevenhe34623 жыл бұрын

    Good vid!

  • @pynchia4119
    @pynchia41193 жыл бұрын

    How to generate the SQL for the models?

  • @JokerJax
    @JokerJax11 ай бұрын

    can we connect data and automatically create erd

  • @roxinnjeru5837
    @roxinnjeru58374 жыл бұрын

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

  • @nessacampbell142
    @nessacampbell1424 жыл бұрын

    @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

    @ABC-333

    2 жыл бұрын

    Yes please

  • @bugsqli9301

    @bugsqli9301

    11 ай бұрын

    👍

  • @fikirtezewdie6708
    @fikirtezewdie67083 жыл бұрын

    Very useful

  • @darkpekka1745
    @darkpekka17455 жыл бұрын

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

  • @lys6009
    @lys6009 Жыл бұрын

    Cool!

  • @cerfux
    @cerfux2 жыл бұрын

    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?

  • @fannypastor4942
    @fannypastor49424 жыл бұрын

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

  • @havelboumbidi440

    @havelboumbidi440

    4 жыл бұрын

    I think you add the data type in your data dictionary

  • @makmo3gza
    @makmo3gza3 жыл бұрын

    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

  • @debapratimchanda8326
    @debapratimchanda83263 жыл бұрын

    thanx bro thanx bro'

  • @_ifly
    @_ifly3 жыл бұрын

    how to add new line .

  • @phrjcf
    @phrjcf2 жыл бұрын

    💯💯

  • @DavidLevy-rh2os
    @DavidLevy-rh2osАй бұрын

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

  • @NostraDavid2
    @NostraDavid2 Жыл бұрын

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

  • @nelamminz1107
    @nelamminz11073 жыл бұрын

    Which app

  • @JoseGejunVanBoy
    @JoseGejunVanBoy3 ай бұрын

    What app is this?

  • @manishadhikari7050
    @manishadhikari7050 Жыл бұрын

    Is it entity relations or crows foot

  • @bugsqli9301

    @bugsqli9301

    11 ай бұрын

    👍

  • @samsmith8691
    @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

    @bugsqli9301

    11 ай бұрын

    Ryt

  • @ruggeddog3103
    @ruggeddog31033 жыл бұрын

    soo GITMIND.COM OR DRAW.IO ???

  • @drawioapp

    @drawioapp

    3 жыл бұрын

    easy one ;-)

  • @ayalilichan2654
    @ayalilichan26544 жыл бұрын

    nao achei em portugues, vai em ingles mesmo kkkkkk

  • @josefinamagallanes8451
    @josefinamagallanes84513 жыл бұрын

    is this free?

  • @HansvanDam1944
    @HansvanDam19443 жыл бұрын

    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

    @heatherstark5003

    Жыл бұрын

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

  • @joannaliezl3844
    @joannaliezl38442 жыл бұрын

    the sound is not good I am quite disappointed

  • @DaRyteJuan
    @DaRyteJuan3 жыл бұрын

    UGH! The music!!! 🤮

  • @user-ti7me6yv7w
    @user-ti7me6yv7w Жыл бұрын

    My crapy teacher tells everyone to label the line, and don't make it looks like a process. What can I say, I just write all 'has' customer has payment detail, the bank has payment detail and team member has the payment detail, fuck

  • @techaddictdude

    @techaddictdude

    Жыл бұрын

    lol

  • @Hector21211
    @Hector21211 Жыл бұрын

    jajaja wesbrok y lebrom juegan tan iguales que los dos engañan con numeros