How to Make and Use an ERD/EER Diagram in MYSQL Workbench

@MattMacarty
#mysql #ERD #EER

Generate and EER (Enhanced Entity Relationship) Diagram with MySQL Workbench. Simply generate the diagram and export it as a graphic or use the diagram and resulting model to create and modify databases. You can also push design modifications made graphically through to an existing database.
Reverse Engineer Database
Forward Engineer Database
Synchronize Database

[robertlongoria]

I have a clear understanding of how to approach this element of rdms(s). Thank you much. BTW others will profit if they read the comments below regarding Primary and Foreign Keys.

[biraescudero]

Great! I've been using Workbench for 3 years, but never knew how to use EER. Thanks a lot!!!

[marcosgeorgopoulos]

I just wanted to say a quick thank you for this video... it was very clear, concise and helpful, subscribed and liked!

[MsDelta]

Hi, Matt, good morning (for me at least)I am very pleased to have found your YouTube channel.I am checking many of your repositories .Sr - Matt according to my humble experience and
expertise in different fields. Your explanations, gradual speech, modulation and voice sound as well with its contents are EXCELLENT !!, Thanks you very much for your
time in posting / conveying your KNOWLEDGE which I AM ABSORBING THEM!

[wonderng]

Bravo. You explained it better than expected

[kingsleyemeka]

I can't appreciate you enough. Thanks sir Matt

[SRHarkreader]

Excellent! Clear verbal instructions with demonstrations of exactly what I needed to know. Thank you!

[madhupraveen]

thank you matt, it helped a lot to understand ERD !

[boaz]

Thanks for doing this video, it's helping!

[Bakemono]

God bless you, you saved the day! Finally I know how to do those stuff.

[Freelensia]

Thanks for the video. I have the same problem as the other poster. I cannot see relationship lines between the tables.

[lara-rosetadman]

When you make the data type a DECIMAL(), what do you numbers inside the brackets refer to? Thank you :)

[JT-qwcn]

Thank you sir! I just spent like 30 minutes looking for a "create EER" button or something.

[learnprogramming]

will there be two lines between the two tables if we have to connect foreign keys as well as relationship one to many?

[aslizeyy]

when i create a new table on the er diagram page, after the forward engineer, new scheme doesn't contain the new table that I created. what should I do?

[sushantsingh]

Whenever I am creating ER for my design, entities are generated well, but the connecting lines(connection between entities) are not forming, and i have to do manually, each time. what can I do ?

[amelierxse]

how would you check if the foreign keys are working correctly? really useful video btw :)

[zirusgaming]

I am using a mac and for some reason the tools to create the relationship is not there. How do I get the tools on the left hand side. Thank you

[kensonavalle]

What if there's no cardinality show? Whats the error? Thank you in advance!

[miguelalves]

When I reverse engineer I do not get the connections between tables. Is there a way to automatically add these?