How to convert an ER diagram to the Relational Data Model 

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.

2hr of lecture in 11min 🔥♥️

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.

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

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?

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

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😇

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

THIS was quite helpful. Thank you!

is that relational model or crow foot model?

Finally non indian youtuber 😁

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

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

thank u so much

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

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

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

Thankyou for the lecture sir it cleared my doubt

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

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.

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

Jones John Garcia Timothy Anderson William

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

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

Does anyone know the software he is using to create ER diagram? Plz tell me

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.

Hi, the converting document link is not working :(

What happens to the derived attribute? :)

idk if you will reply or no but what is this app name??

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

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

what to do when the relationship is 1:1?

Johnson Jose Brown Sandra Johnson Larry

the guid has problem :)

Er, Conceptual, Logical, Physical, all these confusing models ....smh

are you teaching or studying?

why to put startdate inside department

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

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?

Where does the number of employees gone

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

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

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

Very helpful. Thanks alot

And what about 1 to 1 relation?

Do I need the Attribut „Name“ in the Location Table?

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.

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

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.

Sir, department table should have projectID as foreign key

Is it unnecessary to create the tables "WorksFor", "Manages", and "Controls"? Or did you just leave it undone?

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

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

the link isn't working I have an exam soon can you please update the link asap? Thankyou!

i can't focus his voice xxxxxxxxxxxxxxxxxxxxxxxx

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

U sound like captain kuba

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

Thanks for the video, but the conversion guide is inaccessible

The link no longer works. Can you please provide an updated link?? Thanks!

Thank you very much. It helps with my assignment.

how about the attribute "NumberOfEmployees"?

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

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?

Does anyone have the conversion guide pdf? the link no longer working.

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?

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

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

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

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

Can I still get the document form the conversion guide?

I have a doubt , the locationId in the location table applied from where?

The linked website has already been removed. Could you please share the new link?

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

Thank you sir for very clearly explaination

nice video about ERD

what's the difference between primary key and foregin key?

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

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

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

this tutorial is awesome ✌✌✌

thank you!

thank you it was very helpful

Thank you so much bro, video is super helpful

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

not helpful

Hey How to use rules for aggregation ,where is PK, FK? Thanks in advance

Thank you for this video! Extremely helpful.

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

Super Useful

Ahmed says thanks

Thanx. Good job.

Hey would you be able to look at a ER diagram i did?

thankyou very much sirr :"))

How can a relation can have attributes (works_on)

Awesome

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

tysm bro !

u da best xD

thank you very much.... i appreciate you