Mapping an ER Diagram to Database Design in MySQL (higher quality)

Intended for database beginners wanting to convert an ERD into a working database in MySQL. Basic knowledge of ERD is assumed.

[@staje6936]

Katherine, kudos to you for this excellent video. Undoubtedly the best tutorial I have found on KZbin for MySQL and Workbench. I have learned so much here. I didn't even know the “back tick”; a small part of the tutorial but very useful to know. I am surprised that your Subscriptions are not in the tens of thousands.

[@ezrambaile7158]

Kudos to you madam

[@Bluemonkey123]

very good explanation!! Thanks for sharing!!

[@TheProblembaer2]

Thank you for sharing. It was so helpful. Best wishes from germany.

[@andinoasuquo8418]

you are just the best .

[@johnjohnson7538]

Thanks for sharing this video! One question, in your ERD as posted on Blackboard, you say that a location can be occupied by zero or more employees. On the diagram produced by MySQL workbench, the same relationship is indicated with a minimum cardinality of one. That is, a location must at least be occupied by one employee. When, and how, do you impose the minimum cardinality of zero? Similarly, how do you impose the minimum cardinality of one?

[@romanlukichev4971]

27:57

[@galisjordi]

great video! thanks a lot! is it possible to download the pdf with the data types? thanks!!!

[@geoffreykizito4926]

I need help with my ER diagram, can you please help me?