How to convert an ER diagram to the Relational Data Model
HTML-код
- Опубликовано: 8 июл 2024
- 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. Хобби
Great video. Concise and straight to the point. Thanks a lot.
God bless you I was searching for two days for this !! thank you very Much, Bro
Thank u so much!! You Cleared the concepts in a single example 😄
THIS was quite helpful. Thank you!
Hey and thx for watching and commenting!
Thank you. The ER diagram website is useful for my database homework.
Brilliant video. A gem of a video for this topic, possibility the best on youtube :)
Hey and thx for watching and commenting!
Super and very easy to understand ! Just like a school teacher.
Life saver!!!!
Extremely simplified and well explained ❤❤❤❤❤
Hey and thx for watching and commenting!
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
Thank you for this video! Extremely helpful.
Was able to make a relational data model without any prior experience. This model will be used for many great things.
Great explanation. Simple to understand. Thank you so much...
Hey and thx for watching and commenting!
Best video ever....don't stop uploading man
this is good lecture can help many people who need to understand about ERD
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.
Great video cleared all doubts and very good explanation
Extremely useful, thank you for sharing sir.
Thank you very much bro♥️ You are a life saver!!
Hey and thx for watching and commenting!
Very helpful, cleared a lot of doubts : )
Hey and thx for watching and commenting!
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?
Thank you sir for very clearly explaination
Thank you very much. It helps with my assignment.
Please could you share the guide that you showed in the video to translate ER diagram to the Relational Data Model.
Thank you for the tutorial. But I had question about the NumberOfEmployees attribute. Did you ignore it or it doesn't belong anywhere?
Great video
I have to do this whole presentation for class and also do the data input in sql
2hr of lecture in 11min 🔥♥️
Hey and thx for watching and commenting!
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😇
How did it go? I got my exam coming soon too lol
Thank you so much bro, video is super helpful
Thank you, Easy to understand
Hey and thx for watching and commenting!
so touching for an excellent video
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
Hey this video is really helpful!! Can you post more on creating ER diagram from a given situation/problem statement?
thank you sooo much for this explanation
Really helpful video!
for the multivalued location is it better to put the PK of the department on the location table as a foreign key?
Thank you so much. very clear
Perfect , God bless you ..
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.
Very helpful video... Helped me a lot in my exam
Hey and thx for watching and commenting!
perfect and well explained thank you
Hey Kopano and thank you for watching the videos!
That's amazing thank you soooooo much!!!
Thank you for explaining C:
Hey and thx for watching and commenting!
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.
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.
Thanks!
very helpful, thank you!
Hey and thx for watching and commenting!
Thankyou for the lecture sir it cleared my doubt
Many thanks really helpful.
nice video about ERD
Thank you, sir ...all concepts are clear
Hey Suman, and thank you for stopping by the video!
To the point. Great video
Hey and thx for watching and commenting!
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?
this is probably very late but we did that because its a many to many relation
Great video thanks 👍
Thanks for the video but you made table for works on but didn't make one for manage why?
It still looks like DepartmentID can only have 1 LocationID. How would you have multiple locations?
THANKS FOR YOUR SHARING
Hey and thx for watching and commenting!
this tutorial is awesome ✌✌✌
Very helpful. Thanks alot
Hey and thx for watching and commenting!
Someone please tell me why the startdate attribute is in the department table?
awesome, thanks!
Quick question. Why is NumberOfEmployees not represented in the relational model?
For one to one relationship we have to create a different table?
Why was the derived attribute ignored?
Also, can the StartDate attribute rather be in the Employee table?
thanks!
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.
Really helpful!
Thank you very much!!
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?
thank you very much.... i appreciate you
Hi can you tell me the website link that you use to draw this? or tell me a software to do this easyly
Super Useful
amazingly good thanks
hi. thank for this video. do you have some tuto about mapping edr?
Thanx. Good job.
you are the best!
Hey How to use rules for aggregation ,where is PK, FK? Thanks in advance
what to do when the relationship is 1:1?
Does anyone know the software he is using to create ER diagram? Plz tell me
thank u so much
Q: Shouldn't the derived attribute be added at the Department table? If No what's the point of having it?
so satisfying🔥🔥❤️❤️
Hey and thx for watching and commenting!
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.
What do you do with the derived attribute?
@Søren Spangsberg Jørgensen Can you please share the guide, that you showed in the video?
Hey and thx for watching and commenting on it. You can find the guide here: learningeachday.dk/docs/FromERToRDMConversionGuide.pdf
life saver
thanks man
Hey and thx for watching and commenting!
Does anyone have the conversion guide pdf? the link no longer working.
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.
Nice Content, Keep it up.
Hey and thx for watching and commenting!
Thank u so so so much!!!
Hey and thx for watching and commenting!
This is great! What is 'number of employees'? and how is it factored into the relational model?
Thx :) numberOfEmployees is a derived (calculated) attribute.
THANK YOU SOO MUCH
Is participation somehow reflected in a relational schema? For example, if one entity can participate in 0 or more relations with another entity.
Yes, the arrows should be different. It depends on the style you choose, there is Chen notation, UML notation, etc.
I have a doubt , the locationId in the location table applied from where?
Brilliant!! Thankss
what's the difference between primary key and foregin key?
Thank you so much 🙂🙃
Hey and thx for watching and commenting!
why to put startdate inside department
Thank you!
thank you
it was very helpful
hey! thanks for this video :)) I can't get access to the link of the guide tho...
keep it up. nice job.
Hey and thx for watching and commenting!
Thanks a lot. This is what I was looking for. Can anybody tell me that how I can convert a weak entity set? I mean a new table with strong entity set's foreign key or how?
you do not need to convert it, you just need to choose a weak entity set. It is called ER table 2, it is right next to PK table
@@karlomijoc3141 I just saw your comment, thank you
is that relational model or crow foot model?
The linked website has already been removed. Could you please share the new link?