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.
Link to conversion guide: learningeachday.dk/docs/FromE...
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.

[@andrewkontoh6060]

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

[@HyperDev00]

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

[@saumya9226]

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

[@provishu]

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

[@Henryfox112]

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

[@skincarver666]

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

[@Fikayoz]

THIS was quite helpful. Thank you!

[@srenspangsbergjrgensen2419]

Hey and thx for watching and commenting!

[@ahaleem98]

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

[@srenspangsbergjrgensen2419]

Hey and thx for watching and commenting!

[@apurbaafiat6012]

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

[@shijajagwa5210]

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

[@robertsedgewick1266]

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

[@srenspangsbergjrgensen2419]

Hey and thx for watching and commenting!

[@snehashrinivas2173]

Thank you for this video! Extremely helpful.

[@ramashivareddy6871]

Great video cleared all doubts and very good explanation

[@vaiebhavpatil2340]

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

[@namvu607]

Extremely useful, thank you for sharing sir.

[@zo2600]

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

[@srenspangsbergjrgensen2419]

Hey and thx for watching and commenting!

[@dswalkij3201]

Thank you very much. It helps with my assignment.

[@janhavishrivastava9979]

Thank you sir for very clearly explaination

[@architshinde3977]

Very helpful, cleared a lot of doubts : )

[@srenspangsbergjrgensen2419]

Hey and thx for watching and commenting!

[@thuatnguyen4942]

so touching for an excellent video

[@iamhaizam]

Thank you very much bro♥️ You are a life saver!!

[@srenspangsbergjrgensen2419]

Hey and thx for watching and commenting!

[@sakshamjain3998]

Thankyou for the lecture sir it cleared my doubt

[@lalithasadanandan2502]

2hr of lecture in 11min 🔥♥️

[@srenspangsbergjrgensen2419]

Hey and thx for watching and commenting!

[@bhusandatta1968]

Thank you, Easy to understand

[@srenspangsbergjrgensen2419]

Hey and thx for watching and commenting!

[@cc22079]

Great video
I have to do this whole presentation for class and also do the data input in sql

[@brahimchebli7781]

Perfect , God bless you ..

[@twenty1pilots_st]

Thank you so much bro, video is super helpful

[@yashikaarora1460]

thank you sooo much for this explanation

[@vivekchopra8274]

Great video man...... u deserve some applause......I' 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😇

[@nothingold5872]

How did it go? I got my exam coming soon too lol

[@paraschavan485]

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

[@srenspangsbergjrgensen2419]

Hey and thx for watching and commenting!

[@kopanogould4070]

perfect and well explained thank you

[@srenspangsbergjrgensen2419]

Hey Kopano and thank you for watching the videos!

[@sumantech10]

Thank you, sir ...all concepts are clear

[@srenspangsbergjrgensen2419]

Hey Suman, and thank you for stopping by the video!

[@chamilsachintha9698]

Thank you so much. very clear

[@coin5207]

Really helpful video!

[@HX-uq2gr]

That's amazing thank you soooooo much!!!

[@nedaghamari7902]

Many thanks really helpful.

[@go_fuck_yourself]

To the point. Great video

[@srenspangsbergjrgensen2419]

Hey and thx for watching and commenting!

[@sphiwemposula5787]

Very helpful. Thanks alot

[@srenspangsbergjrgensen2419]

Hey and thx for watching and commenting!

[@zixinyin2757]

very helpful, thank you!

[@srenspangsbergjrgensen2419]

Hey and thx for watching and commenting!

[@nomadnomad7738]

Thanx. Good job.

[@fcb4281]

Great video thanks 👍

[@bassamtk714]

this tutorial is awesome ✌✌✌

[@krishnaTiwari851]

thank you very much.... i appreciate you

[@arshah246]

THANKS FOR YOUR SHARING

[@srenspangsbergjrgensen2419]

Hey and thx for watching and commenting!

[@Engycation]

nice video about ERD

[@xsaberalter]

Thank you very much!!

[@puppettrailers7860]

Thank you for explaining C:

[@srenspangsbergjrgensen2419]

Hey and thx for watching and commenting!

[@barnabasmeszaros8244]

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.

[@sokolom]

amazingly good thanks

[@anuragnagpal]

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

[@MOM777100]

you are the best!

[@sobkhed1716]

thank you
it was very helpful

[@abu5197]

Really helpful!

[@maheshnahak9510]

awesome, thanks!

[@kiranghimire6070]

so satisfying🔥🔥❤️❤️

[@srenspangsbergjrgensen2419]

Hey and thx for watching and commenting!

[@techxpr2]

Super Useful

[@tungochuy]

thank u so much

[@mohamedhashem1938]

life saver
thanks man

[@srenspangsbergjrgensen2419]

Hey and thx for watching and commenting!

[@rusolaboasbeh2263]

THANK YOU SOO MUCH

[@un1kum42]

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.

[@afshanparkar2678]

Please could you share the guide that you showed in the video to translate ER diagram to the Relational Data Model.

[@muhammadjamilhusni4066]

Thank you!

[@viktorijasrebrenova]

Thank u so so so much!!!

[@srenspangsbergjrgensen2419]

Hey and thx for watching and commenting!

[@kartikbhanderi9210]

Thank you so much 🙂🙃

[@srenspangsbergjrgensen2419]

Hey and thx for watching and commenting!

[@versatilevocal3286]

Brilliant!! Thankss

[@SyedDanishTech]

Nice Content, Keep it up.

[@srenspangsbergjrgensen2419]

Hey and thx for watching and commenting!

[@HungNguyen-uc7jq]

Thank you,sir

[@srenspangsbergjrgensen2419]

Hey and thx for watching and commenting!

[@mohsenmohamed593]

Very nice very awesome pls go ahead with a new lessons 😂❤️❤️❤️

[@ranjithr6046]

thanks 😃

[@yasurfer]

Very interesting video except for the normalization 1NF, 2NF ... XNF especially for the table department.

[@ORION-ir5dx]

Thank you.

[@tipsblender1538]

keep it up. nice job.

[@srenspangsbergjrgensen2419]

Hey and thx for watching and commenting!

[@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.

[@srenspangsbergjrgensen2419]

Hey and thx for watching and commenting! I have reviewed the video and the theory behind and your are correct. DepartmentID should indeed be part of the Locations table. Otherwise it will be a 1:N relationship. I will note it in the video and the comments. Thank you for noting this mate.

[@mumbaikachallenge5526]

Thanks!

[@maghfiraazzahra3482]

thankyou very much sirr :"))

[@butterdawg1918]

very helpful video! However, they taught me an attribute on a 1 to many relation isn't allowed (startDate on the relation 'manages') is this correct?

[@atlasmazigh666]

Thanks bro

[@johnkasonga6634]

Thank you for the tutorial. But I had question about the NumberOfEmployees attribute. Did you ignore it or it doesn't belong anywhere?

[@gracefulleey]

Hi, thanks for the helpful video! I would like to have the updated link to the conversion guide. It seems like the link is invalid.

[@saud892]

Thank you for the tutorial, can you provide a new link for the ER conversion guide.? Since the one in description doesn't work. Thanks

[@curiousseeker3784]

thanks chad

[@8dmusicstudio930]

Great 🔥🔥🔥

[@srenspangsbergjrgensen2419]

Hey and thx for watching and commenting!

[@E0M]

tysm bro !

[@mohitagrawal1555]

thank bro

[@_YuvrajChauhan]

Thank you

[@srenspangsbergjrgensen2419]

Hey and thx for watching and commenting!

[@mrYtuser01]

for the multivalued location is it better to put the PK of the department on the location table as a foreign key?

[@honey-py9pj]

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?

[@mealsome5286]

this is probably very late but we did that because its a many to many relation

[@Weranga-Rathnayaka]

Hi can you tell me the website link that you use to draw this? or tell me a software to do this easyly

[@AhmedAshrafMo]

thank you

[@srenspangsbergjrgensen2419]

Hey and thx for watching and commenting!

[@dugtrioramen]

It still looks like DepartmentID can only have 1 LocationID. How would you have multiple locations?

[@abdulbasit0123]

Thanks 🤍

[@saurabhtalele1537]

nice sir

[@obinnankwocha3276]

Why was the derived attribute ignored?
Also, can the StartDate attribute rather be in the Employee table?
thanks!

[@srenspangsbergjrgensen2419]

Hey and thx for watching and commenting! We can calculate / query the derived attribute value based on the other attributes in the DB, therefore a derived attributed should not be created in the DB.

[@danielcampos8986]

very nicee

[@MrKhan-ci3uy]

Awesome

[@AgusJanardana]

Thanks for explaining, this was i search for for exam xD

[@BluePaneTechnologies-nu4hh]

thnx

[@stefanobilleter2556]

hallo! thanks for the video! do you still have the guide? the link is not working anymore! thanks a lot!!

[@WRlGHTlNG]

Quick question. Why is NumberOfEmployees not represented in the relational model?

[@anujsharma8915]

@Søren Spangsberg Jørgensen Can you please share the guide, that you showed in the video?

[@srenspangsbergjrgensen2419]

Hey and thx for watching and commenting on it. You can find the guide here: learningeachday.dk/docs/FromERToRDMConversionGuide.pdf

[@painyahiko8450]

Thanks for the video but you made table for works on but didn't make one for manage why?