Creating Entity Relationship Diagrams using Draw.io 

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

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

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

Is it entity relations or crows foot

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

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

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.

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

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

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

Lose the annoying and unnecessary muzac track.

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

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

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

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

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

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

UGH! The music!!! 🤮

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

Cool!

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

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.

nao achei em portugues, vai em ingles mesmo kkkkkk

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

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

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

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

How to generate the SQL for the models?

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

Thanks a bunch for the clear explanation!

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

can we connect data and automatically create erd

Apakah bisa untuk mengatur garis sparator

Thank you so much. It helped me lot.

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

thank you sir

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

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

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

super amazing video, cant resist to watch & like.

thankyou sir for your bright explaination about erd

very useful video....Thanks a lot

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

This was very well presented! And helpful!

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

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

TG for RU-vid, amazing video

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

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

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

the sound is not good I am quite disappointed

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

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

What a fantastic explanation, thanks a lot👏💯

thanks very much

Thank you very much for your video!

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

Very useful video, thank you for your sharing!

Thank you for the info. Easy to understand

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

Thankyou. This is so Clear tutorial

Thank you sir

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

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

Thank you, great tutorial

Damn it's really helpful

Thank you very much you save me

thanks a lot...it's helpful

What app is this?

Very nice and beginner friendly tutorial. Well done.

Thank you

The music is so annoying

Thanks for this tutorial

So helpful, thank you so much, I

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

Very well defined . Good Job

thank you

how to add new line .

Many thanks Sir!

This was perfect, thank you!

Thank you sir.

Thank you for tutorial, it's really useful

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

tks so much !

Muchas gracias

thanx bro thanx bro'

thanks mate you safe my life

Thanks man.

Thank you!

thank you

is this free?

Which app

Excellent! Thank You!

Thanks!

Very useful

Thanks

thank you very much for this nice tutorial

Good vid!

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

thank you Sir !