How to convert an ER diagram to the Relational Data Model

[@Necromanteion]

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

[@lalithasadanandan2502]

2hr of lecture in 11min 🔥♥️

[@srenspangsbergjrgensen2419]

Hey and thx for watching and commenting!

[@aditya_dede1717]

Great Man. Such KZbinrs are really needed now a days 🤝🏻🥺❤️

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

[@apurbaafiat6012]

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

[@HyperDev00]

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

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

[@robertsedgewick1266]

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

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

[@saumya9226]

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

[@shijajagwa5210]

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

[@Henryfox112]

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

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

[@proxy5061]

Yes, actually we shud have either one more extra table for deptis locid , dptid will be fk so it can be repeated

[@Fikayoz]

THIS was quite helpful. Thank you!

[@srenspangsbergjrgensen2419]

Hey and thx for watching and commenting!

[@andrewkontoh6060]

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

[@deadvision22]

thx brother for this best exp. ı know all northern people if they want is the best programmer in the world

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

[@ahaleem98]

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

[@srenspangsbergjrgensen2419]

Hey and thx for watching and commenting!

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

[@mando2908]

Finally non indian youtuber 😁

[@ziyadAlshareef04]

does not matter

[@easmund6680]

@@ziyadAlshareef04matter

[@proxy5061]

,😅 we don't have 500+ genders in our country 😂, and just to add 😂 u r non Indian youtubers are busy in prawn 🍤 sites

[@asem8103]

indians are awesome

[@M_3553]

Raci$t

[@auditor9927]

there is a small remark: relation manages has an attribute so it should be converted into a table having 2 tables PK in addition to attribute start date

[@anuragnagpal]

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

[@paraschavan485]

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

[@srenspangsbergjrgensen2419]

Hey and thx for watching and commenting!

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

[@sinastb]

Hi, thanks for the video. BTW, link to conversion guide is not working.

[@VsEdits59]

yup same here

[@snehashrinivas2173]

Thank you for this video! Extremely helpful.

[@afshanparkar2678]

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

[@provishu]

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

[@zo2600]

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

[@srenspangsbergjrgensen2419]

Hey and thx for watching and commenting!

[@ramashivareddy6871]

Great video cleared all doubts and very good explanation

[@sakshamjain3998]

Thankyou for the lecture sir it cleared my doubt

[@dswalkij3201]

Thank you very much. It helps with my assignment.

[@JohnWick-tv6wr]

Great Explanation. I have one think to say. I think you missed a Derived Attribute called NumbersOfEmployees. Is there any intention for that? If you really missed it, give me a idea how to do that. Thank you.

[@cc22079]

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

[@dreamygroves]

Q1: CONVERT Following Entity Relational Diagram into Ralations and also write SQL commands for designing these relation into Oracal Database. This question solve from the given table in video

[@srenspangsbergjrgensen2419]

Hey and thx for watching and commenting!

[@namvu607]

Extremely useful, thank you for sharing sir.

[@presentlee9403]

My English isn't good. His accent is just fine for me. Good work dude!

[@srenspangsbergjrgensen2419]

Hey and thx for watching and commenting!

[@architshinde3977]

Very helpful, cleared a lot of doubts : )

[@srenspangsbergjrgensen2419]

Hey and thx for watching and commenting!

[@iamhaizam]

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

[@srenspangsbergjrgensen2419]

Hey and thx for watching and commenting!

[@janhavishrivastava9979]

Thank you sir for very clearly explaination

[@twenty1pilots_st]

Thank you so much bro, video is super helpful

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

[@thuatnguyen4942]

so touching for an excellent video

[@sphiwemposula5787]

Very helpful. Thanks alot

[@srenspangsbergjrgensen2419]

Hey and thx for watching and commenting!

[@misshello55]

Love uuuuuu 💋💋💋💋 a savior fr

[@bhusandatta1968]

Thank you, Easy to understand

[@srenspangsbergjrgensen2419]

Hey and thx for watching and commenting!

[@mohsenmohamed593]

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

[@indian_otaku2388]

Unfortunately the link to conversion guide aint working for me 😥. Great video btw thanks 🔥🔥🔥

[@yashikaarora1460]

thank you sooo much for this explanation

[@chaosolid]

I think it didn't include the constraint, participation(full/partial) ...

[@srenspangsbergjrgensen2419]

Hey and thx for watching and commenting!

[@sumantech10]

Thank you, sir ...all concepts are clear

[@srenspangsbergjrgensen2419]

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

[@omerutkuerzengin3061]

Du bist toll!

[@speconcloud9]

what to do when the relationship is 1:1?

[@kopanogould4070]

perfect and well explained thank you

[@srenspangsbergjrgensen2419]

Hey Kopano and thank you for watching the videos!

[@yasurfer]

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

[@johnkasonga6634]

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

[@the-master-of-jizz]

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?

[@saada4668]

Very helpful. Thanks alot, but I think that the relationship of Employee manages Department is one to one relationship not one to many. THANKS

[@whatever7338]

IRL one person can manage multiple departments.

[@Sebastian-zs8cp]

What im not anderstand the Location in Two Babbel. Why do you dont use the racktingle and reagionships?

[@fevancampenhout7576]

hey! thanks for this video :)) I can't get access to the link of the guide tho...

[@aibknada1300]

thanks please can you answer me 😔 can we move ProductId to department table ? we can have relationship right??

[@srenspangsbergjrgensen2419]

If you refer to ProjectID then no, since Department-Project has a 1:N relationsship and therefore we must put a Foreign Key from the 1-side (departmentID) to the N-side (Project table). Hope it makes sense.

[@aibknada1300]

@@srenspangsbergjrgensen2419 thnx

[@HX-uq2gr]

That's amazing thank you soooooo much!!!

[@dugtrioramen]

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

[@toronto8323]

Great Video. Is the guide available for sharing?

[@srenspangsbergjrgensen2419]

If you mean the video, then yes. It is public.

[@satashreeroy1652]

@@srenspangsbergjrgensen2419 Is that conversion guide available for sharing?

[@painyahiko8450]

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

[@Issam_seb]

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

[@chamilsachintha9698]

Thank you so much. very clear

[@coin5207]

Really helpful video!

[@zixinyin2757]

very helpful, thank you!

[@srenspangsbergjrgensen2419]

Hey and thx for watching and commenting!

[@nedaghamari7902]

Many thanks really helpful.

[@deeptha20]

why manage relation didn't create new table because it has an attribute called startdate, because you create it for workson relational with hours attribute.

[@krishnaTiwari851]

thank you very much.... i appreciate you

[@fcb4281]

Great video thanks 👍

[@bassamtk714]

this tutorial is awesome ✌✌✌

[@FabrikaKarpos-lf2cu]

does it matter which way the arrows point when connecting the tables at the end?

[@YaredGirma-o9q]

Yes,ofcourse

[@virusthekid]

Aren’t we supposed to take the primary key on the many side and store it in the 1 side?… I’m just asking cuz that’s what our lecturer taught us

[@nuraleesajuani3644]

How do you convert an eerd to a relational model? Where they have subtypes.

[@Kokurorokuko]

There are many ways. You can have children table with duplicated attributes. Or a parent table and children tables. Or a parent table with attribute type referencing Type table. It also depends on if it's a overlapping/disjoint total/partial inheritance.

[@FabrikaKarpos-lf2cu]

are there any examples with more complex models? with double line relations?

[@Engycation]

nice video about ERD

[@honglinhvuong3736]

Thanks for the video, but the conversion guide is inaccessible

[@abhishekdhyade7500]

The multivalued location table should have had dept I'd instead of the dept table having location id? Also the start date should have belonged to employee table and not the dept table. Can anyone help me out here?

[@KrishnaSeshu]

Conversion Guide PDF - NOT FOUND

[@srenspangsbergjrgensen2419]

spangsberg.net/dl/FromERToRelationalModel.pdf

[@parthik6223]

is that relational model or crow foot model?

[@MAXHTEC94XQCL]

Q: Shouldn't the derived attribute be added at the Department table? If No what's the point of having it?

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

[@truegamingbyjadon3662]

For one to one relationship we have to create a different table?

[@mohamedhashem1938]

life saver thanks man

[@srenspangsbergjrgensen2419]

Hey and thx for watching and commenting!

[@kiranghimire6070]

so satisfying🔥🔥❤️❤️

[@srenspangsbergjrgensen2419]

Hey and thx for watching and commenting!

[@puppettrailers7860]

Thank you for explaining C:

[@srenspangsbergjrgensen2419]

Hey and thx for watching and commenting!

[@AgusJanardana]

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

[@sureshmakwana8709]

You didn't taught how to map that "NumberOfEmployees" derived attribute to Relational data model!!

[@chandanhegde631]

Derived attributes will not be added as columns to the table. That's the rule. It is 'derived' right? Derived from other attributes

[@sakshi_malla]

Someone please tell me why the startdate attribute is in the department table?

[@brahimchebli7781]

Perfect , God bless you ..

[@itsanurag1111]

why to put startdate inside department

[@kashif3173]

Sir, department table should have projectID as foreign key

[@SyedDanishTech]

Nice Content, Keep it up.

[@srenspangsbergjrgensen2419]

Hey and thx for watching and commenting!

[@MOM777100]

you are the best!

[@xsaberalter]

Thank you very much!!

[@tungochuy]

thank u so much

[@hamiltonrose9500]

hi, what happened to the relations 'manages' and 'works_for'?