How to convert an ER diagram to the Relational Data Model

This video explains how you can convert an Entity Relational diagram into the Relational Data Model.

PLEASE NOTE at 11:00: The conversion of the multi-valued attribute of the Department is NOT being correctly mapped in the video. departmentID should be put as a Foreign Key on the Locations table and together departmentID and locationID form the combined Primary Key as specified in the conversion guide.

[vivekchopra]

Great video u deserve some m having my database exam on 11 th nd i was having confusions in retaional data model. But, I learnt from this vedio, now i fell i can do well in my exam😇

[skincarver]

Was able to make a relational data model without any prior experience. This model will be used for many great things.

[saumya]

Thank u so much!! You Cleared the concepts in a single example 😄

[robruizr]

Shouldn't DepartmentID be part of the Locations table? This instead of LocationID being part of the Department table. Department-Location becomes a 1:M relationship once you convert Locations into a new table, which causes the PKey of side 1 to become a FKey in side M.

[ahaleem]

Life saver!!!!
Extremely simplified and well explained ❤❤❤❤❤

[Henryfox]

Thank you. The ER diagram website is useful for my database homework.

[HyperDev]

God bless you I was searching for two days for this !! thank you very Much, Bro

[shijajagwa]

this is good lecture can help many people who need to understand about ERD

[andrewkontoh]

Great video. Concise and straight to the point. Thanks a lot.

[vaiebhavpatil]

was very helpful, u managed to explain 1:n, m:n, derived attributes, multi valued attributes and many other things with a single example, it was great. subscribed :D

[unkum]

I am sorry that I have to say, that I as a German, had to laugh about your name but after that you saved my ass with that video.

[robertsedgewick]

Brilliant video. A gem of a video for this topic, possibility the best on youtube :)

[anuragnagpal]

Hey this video is really helpful!! Can you post more on creating ER diagram from a given situation/problem statement?

[paraschavan]

Very helpful video... Helped me a lot in my exam

[barnabasmeszaros]

Hello, I have a question. Revising the Department - Location relationship, I think the Location should store the DepartmentID as multiple locations are available for one single department. So, if I see things correctly, a LocationID in the Department table cannot handle multiple locations.

[honey-pypj]

Why for the relation "works on" we created a seperate table, but for the others relations ("work for" .. and so on) we added attributes to the already existed entity sets instead?

[provishu]

Super and very easy to understand ! Just like a school teacher.

[zo]

Great explanation. Simple to understand. Thank you so much...

[apurbaafiat]

Best video ever....don't stop uploading man

[ramashivareddy]

Great video cleared all doubts and very good explanation