DEV Community

Cover image for ER Diagram to Relational Model Conversion

ER Diagram to Relational Model Conversion

Ketan Patil on September 27, 2020

First step of any relational database design is to make ER Diagram for it and then convert it into relational Model. What is relational model ? Rel...
Collapse
 
anenthusiastic profile image
Info Comment hidden by post author - thread only accessible via permalink
Fatih

M:1 and !:M relationships are wrong in this article. Primary key of the 1-side entity should be in M-side entity as foreign key. But here it is explained in the opposite way.Please correct them. Also M:1 and 1:M relationships are same. Why did you explain them 2 times

Collapse
 
vrajdesai78 profile image
Vraj Desai

Thank you for this blog. I have read this blog before exam and I scored good marks in this portion. I appreciate your efforts

Collapse
 
ketan_patil profile image
Ketan Patil

Thats Great!
Your welcome.

Collapse
 
pivosok profile image
Info Comment hidden by post author - thread only accessible via permalink
Osmanlija

Thats not correct. The foreign key field should be on many side. Not one

Collapse
 
ranafab18 profile image
Info Comment hidden by post author - thread only accessible via permalink
Raziq

In the other tutorials I have watched and articles I have read, the primary key of the "one" part of the relationship becomes the foreign key of the "many" part of the relationship.

Some comments have been hidden by the post's author - find out more