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😇
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.
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
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?
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.
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.
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.
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.
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
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?
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?
2hr of lecture in 11min 🔥♥️
Hey and thx for watching and commenting!
Was able to make a relational data model without any prior experience. This model will be used for many great things.
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 u so much!! You Cleared the concepts in a single example 😄
Finally non indian youtuber 😁
does not matter
@@ziyadAlshareef04matter
,😅 we don't have 500+ genders in our country 😂, and just to add 😂 u r non Indian youtubers are busy in prawn 🍤 sites
this is good lecture can help many people who need to understand about ERD
Hey this video is really helpful!! Can you post more on creating ER diagram from a given situation/problem statement?
Thank you. The ER diagram website is useful for my database homework.
THIS was quite helpful. Thank you!
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!
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
Very helpful video... Helped me a lot in my exam
Hey and thx for watching and commenting!
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
Brilliant video. A gem of a video for this topic, possibility the best on youtube :)
Hey and thx for watching and commenting!
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.
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
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.
Yes, actually we shud have either one more extra table for deptis locid , dptid will be fk so it can be repeated
Thankyou for the lecture sir it cleared my doubt
Great explanation. Simple to understand. Thank you so much...
Hey and thx for watching and commenting!
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.
Super and very easy to understand ! Just like a school teacher.
Best video ever....don't stop uploading man
Very interesting video except for the normalization 1NF, 2NF ... XNF especially for the table department.
Thank you for this video! Extremely helpful.
Thank you very much. It helps with my assignment.
Great video
I have to do this whole presentation for class and also do the data input in sql
Very helpful. Thanks alot, but I think that the relationship of Employee manages Department is one to one relationship not one to many. THANKS
IRL one person can manage multiple departments.
Thank you sir for very clearly explaination
Please could you share the guide that you showed in the video to translate ER diagram to the Relational Data Model.
is that relational model or crow foot model?
My English isn't good. His accent is just fine for me. Good work dude!
Hey and thx for watching and commenting!
Great video cleared all doubts and very good explanation
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.
Very nice very awesome pls go ahead with a new lessons 😂❤️❤️❤️
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. Thanks alot
Hey and thx for watching and commenting!
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.
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
Hey and thx for watching and commenting!
Unfortunately the link to conversion guide aint working for me 😥. Great video btw thanks 🔥🔥🔥
Thank you, Easy to understand
Hey and thx for watching and commenting!
thank u so much
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.
I think it didn't include the constraint, participation(full/partial) ...
Hey and thx for watching and commenting!
Very helpful, cleared a lot of doubts : )
Hey and thx for watching and commenting!
so touching for an excellent video
It still looks like DepartmentID can only have 1 LocationID. How would you have multiple locations?
Thank you for the tutorial. But I had question about the NumberOfEmployees attribute. Did you ignore it or it doesn't belong anywhere?
what to do when the relationship is 1:1?
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
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?
perfect and well explained thank you
Hey Kopano and thank you for watching the videos!
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?
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
THANKS FOR YOUR SHARING
Hey and thx for watching and commenting!
To the point. Great video
Hey and thx for watching and commenting!
Hi, thanks for the video. BTW, link to conversion guide is not working.
yup same here
thank you sooo much for this explanation
Thank you, sir ...all concepts are clear
Hey Suman, and thank you for stopping by the video!
nice video about ERD
Q: Shouldn't the derived attribute be added at the Department table? If No what's the point of having it?
Thank you so much bro, video is super helpful
Perfect , God bless you ..
For one to one relationship we have to create a different table?
Thanks for the video but you made table for works on but didn't make one for manage why?
Does anyone know the software he is using to create ER diagram? Plz tell me
for the multivalued location is it better to put the PK of the department on the location table as a foreign key?
You didn't taught how to map that "NumberOfEmployees" derived attribute to Relational data model!!
Derived attributes will not be added as columns to the table. That's the rule. It is 'derived' right? Derived from other attributes
why to put startdate inside department
hi, what happened to the relations 'manages' and 'works_for'?
very helpful, thank you!
Hey and thx for watching and commenting!
Someone please tell me why the startdate attribute is in the department table?
Is it unnecessary to create the tables "WorksFor", "Manages", and "Controls"?
Or did you just leave it undone?
Many thanks really helpful.
hey! thanks for this video :)) I can't get access to the link of the guide tho...
this tutorial is awesome ✌✌✌
Thanks for the video, but the conversion guide is inaccessible
Super Useful
Quick question. Why is NumberOfEmployees not represented in the relational model?
Thank you so much. very clear
thank you very much.... i appreciate you
what's the difference between primary key and foregin key?
how about the attribute "NumberOfEmployees"?
I have a doubt , the locationId in the location table applied from where?
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
Thank you for explaining C:
Hey and thx for watching and commenting!
Sir, department table should have projectID as foreign key
That's amazing thank you soooooo much!!!
life saver
thanks man
Hey and thx for watching and commenting!
Thank you,sir
Hey and thx for watching and commenting!
And what about 1 to 1 relation?
Great video thanks 👍
Hi, the converting document link is not working :(
So how to convert relational model into the normal er diagram?
Hey How to use rules for aggregation ,where is PK, FK? Thanks in advance
Thanx. Good job.
The link no longer works. Can you please provide an updated link?? Thanks!
What happens to the derived attribute? :)