Creating Entity Relationship Diagrams using Draw.io

Поділитися
Вставка
  • Опубліковано 22 гру 2024

КОМЕНТАРІ • 131

  • @loebys
    @loebys Рік тому +21

    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

  • @kelleyannbart8348
    @kelleyannbart8348 Рік тому +4

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

  • @HolyApplebutter
    @HolyApplebutter Рік тому +1

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

  • @JoyJoy-u5m
    @JoyJoy-u5m 9 місяців тому +1

    its been 4 years but this video is still helpful!

  • @aaronzeka3196
    @aaronzeka3196 2 роки тому +2

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

  • @LePhenixGD
    @LePhenixGD 2 роки тому +9

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

  • @rohitxess1955
    @rohitxess1955 5 років тому +12

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

  • @quanleliu8825
    @quanleliu8825 Рік тому

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

  • @zappertxt
    @zappertxt 4 роки тому +20

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

    • @danielmaserrat5060
      @danielmaserrat5060 3 роки тому +1

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

  • @jospintedjou276
    @jospintedjou276 Рік тому

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

  • @LGmediaGlobal
    @LGmediaGlobal 3 роки тому +1

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

  • @fraganya
    @fraganya 4 роки тому +2

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

  • @riyagoswami4925
    @riyagoswami4925 4 роки тому +11

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

  • @Gaminiheraliyawala
    @Gaminiheraliyawala 2 роки тому +1

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

  • @bunderbah
    @bunderbah 2 роки тому

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

  • @chujekwu
    @chujekwu 5 років тому +4

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

  • @djamalinfo2322
    @djamalinfo2322 Рік тому

    What a fantastic explanation, thanks a lot👏💯

  • @RA-do6et
    @RA-do6et 2 роки тому +32

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

  • @myriadpro1641
    @myriadpro1641 10 місяців тому

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

  • @bunnychan1633
    @bunnychan1633 2 місяці тому

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

  • @blossomnature6257
    @blossomnature6257 2 роки тому

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

  • @emilianogomez2071
    @emilianogomez2071 7 місяців тому

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

  • @IrynaOleksandrivnaDemydova
    @IrynaOleksandrivnaDemydova Рік тому

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

  • @andrewwoan
    @andrewwoan 4 роки тому +3

    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

  • @chowkisanjana1337
    @chowkisanjana1337 2 місяці тому

    Thanks a bunch for the clear explanation!

  • @rahi187
    @rahi187 2 роки тому

    super amazing video, cant resist to watch & like.

  • @AndreiGog-n4h
    @AndreiGog-n4h Рік тому

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

  • @samanthamccarthy9765
    @samanthamccarthy9765 2 місяці тому +1

    thanks very much . very useful quick summary

  • @JokerJax
    @JokerJax Рік тому

    can we connect data and automatically create erd

  • @rafsan2773
    @rafsan2773 Рік тому +2

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

  • @tamask
    @tamask 4 роки тому +3

    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
    @Mark4Jesus 3 роки тому +2

    This was very well presented! And helpful!

  • @efoyawi4834
    @efoyawi4834 3 роки тому +3

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

  • @marylebens1307
    @marylebens1307 5 років тому +1

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

  • @kreatur_
    @kreatur_ 4 роки тому +1

    Very nice and beginner friendly tutorial. Well done.

  • @nessacampbell142
    @nessacampbell142 4 роки тому +4

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

  • @ismulazam7631
    @ismulazam7631 5 місяців тому

    thankyou sir for your bright explaination about erd

  • @InnovativeBeautifulWorld
    @InnovativeBeautifulWorld 2 місяці тому

    Thank you so much. It helped me lot.

  • @vsp2022
    @vsp2022 2 роки тому

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

  • @mthokozisimyende787
    @mthokozisimyende787 Рік тому

    TG for UA-cam, amazing video

  • @kamspal7643
    @kamspal7643 2 роки тому

    Thank you for the info. Easy to understand

  • @pynchia4119
    @pynchia4119 4 роки тому +1

    How to generate the SQL for the models?

  • @anthonypaul378
    @anthonypaul378 3 роки тому

    Thankyou. This is so Clear tutorial

  • @garrydenewaldie7257
    @garrydenewaldie7257 4 роки тому

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

  • @DavidLevy-rh2os
    @DavidLevy-rh2os 6 місяців тому

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

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

    Finally, can I save the design and copy it?

  • @supritamurmu2165
    @supritamurmu2165 3 роки тому +1

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

  • @ibrahimozmen9668
    @ibrahimozmen9668 3 роки тому

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

  • @adrianCoding
    @adrianCoding 8 місяців тому

    Thank you, great tutorial

  • @yaowenzheng3096
    @yaowenzheng3096 2 роки тому

    Very useful video, thank you for your sharing!

  • @coreysheerer8199
    @coreysheerer8199 4 роки тому +1

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

  • @Nagaraj-yv9bt
    @Nagaraj-yv9bt 29 днів тому

    not able change the direction of the relation shape

  • @gauravk5282
    @gauravk5282 2 роки тому

    Very well defined . Good Job

  • @yaohongzhao3605
    @yaohongzhao3605 2 роки тому

    Thank you very much for your video!

  • @ivobaar1761
    @ivobaar1761 2 роки тому

    This is an amazing tutorial. Thanks a lot!

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

  • @makmo3gza
    @makmo3gza 3 роки тому

    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

  • @homelander973
    @homelander973 3 роки тому

    Thank you for tutorial, it's really useful

  • @crashtest1012
    @crashtest1012 3 роки тому

    This was perfect, thank you!

  • @roxinnjeru5837
    @roxinnjeru5837 4 роки тому

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

  • @orwakassab8326
    @orwakassab8326 2 роки тому

    Thanks for this tutorial

  • @DavidIbrahimDavidIbrahim
    @DavidIbrahimDavidIbrahim 2 місяці тому

    Apakah bisa untuk mengatur garis sparator

  • @kiddosknowledgewizbyakshit9954
    @kiddosknowledgewizbyakshit9954 2 роки тому

    very useful video....Thanks a lot

  • @liviasheilla3602
    @liviasheilla3602 5 років тому

    thank you , this video really helped me

  • @TheCrowdel
    @TheCrowdel 4 роки тому

    thanks mate you safe my life

  • @netfanely
    @netfanely 5 років тому

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

    • @havelboumbidi440
      @havelboumbidi440 5 років тому +1

      I think you add the data type in your data dictionary

  • @manishadhikari7050
    @manishadhikari7050 2 роки тому +1

    Is it entity relations or crows foot

  • @_ifly
    @_ifly 3 роки тому

    how to add new line .

  • @cerfux
    @cerfux 3 роки тому

    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?

  • @zafariqbal92
    @zafariqbal92 3 роки тому

    Excellent! Thank You!

  • @HienNguyen-cb8ud
    @HienNguyen-cb8ud 2 роки тому

    Many thanks Sir!

  • @JoseGejunVanBoy
    @JoseGejunVanBoy 8 місяців тому

    What app is this?

  • @md.robelahammed5137
    @md.robelahammed5137 3 роки тому

    thanks a lot...it's helpful

  • @aykutyldz1538
    @aykutyldz1538 5 років тому

    thank you very much for this nice tutorial

  • @digigoliath
    @digigoliath 5 років тому

    Thank you!! Fantastic.

  • @stevenhe3462
    @stevenhe3462 3 роки тому

    Good vid!

  • @miaoruibo3803
    @miaoruibo3803 3 роки тому

    Damn it's really helpful

  • @professionalman2591
    @professionalman2591 3 роки тому +1

    thank you sir

  • @oliviayolosangweni2669
    @oliviayolosangweni2669 4 роки тому

    So helpful, thank you so much, I

  • @NostraDavid2
    @NostraDavid2 Рік тому

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

  • @estfanosekelkay8720
    @estfanosekelkay8720 2 роки тому

    Thank you!

  • @bezualemfisseha2119
    @bezualemfisseha2119 2 роки тому

    Thank you very much you save me

  • @nelamminz1107
    @nelamminz1107 3 роки тому

    Which app

  • @Chuquemeka
    @Chuquemeka 2 роки тому

    Thank you sir.

  • @ayyeyo
    @ayyeyo 2 роки тому

    Thanks man.

  • @oscardavidvalenciaalvarez9200
    @oscardavidvalenciaalvarez9200 2 роки тому

    Muchas gracias

  • @sirdull0205
    @sirdull0205 3 місяці тому

    thanks very much

  • @darkpekka1745
    @darkpekka1745 5 років тому +5

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

  • @huytrinh3823
    @huytrinh3823 4 роки тому

    thank you Sir !

  • @umami07
    @umami07 Рік тому

    tks so much !

  • @cleidsonsantana1401
    @cleidsonsantana1401 4 роки тому

    perfect, thanks !

  • @dentalvideos6175
    @dentalvideos6175 Місяць тому

    perfect
    thanks

  • @tanacing347
    @tanacing347 3 роки тому

    Thanks!

  • @lys95
    @lys95 Рік тому +1

    Cool!

  • @ruggeddog3103
    @ruggeddog3103 4 роки тому

    soo GITMIND.COM OR DRAW.IO ???

  • @musakucuk2224
    @musakucuk2224 4 роки тому

    thank you

  • @samsmith8691
    @samsmith8691 Рік тому +1

    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.

  • @fikirtezewdie6708
    @fikirtezewdie6708 3 роки тому

    Very useful

  • @HansvanDam1944
    @HansvanDam1944 4 роки тому +4

    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 2 роки тому

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

  • @minirose4763
    @minirose4763 5 років тому

    Thanks