0 votes 0 votes while converting one to one relationship from ER diagram to RDMS, without total participation on either side, we can represent the relationship using primary- foreign key contraint without making a new table?? Am i right?? Databases databases er-diagram er-to-relational relational + – sushmita asked Jan 31, 2017 retagged Jun 4, 2017 by Arjun sushmita 1.1k views answer comment Share Follow See all 0 reply Please log in or register to add a comment.
0 votes 0 votes Yes you are correct. As you mentioned for one to one relationships seperate table is not required. But column which is common can be added to etiher one of the two tables involved. Only for many-to-many relationships and multivalued attributes a seperate table is requied. Refer this video link. Everything is explained very clearly in that. https://www.youtube.com/watch?v=R2zxPAoRm_8&index=30&list=PLx5CT0AzDJCnO9k98RsrPY9WGAXj8yeKL Kaushik.P.E answered Jan 31, 2017 Kaushik.P.E comment Share Follow See all 0 reply Please log in or register to add a comment.
0 votes 0 votes Yes, you are right. We need to draw a table for multivalued attributes and many to many relationships. ankit3009 answered Sep 11, 2020 ankit3009 comment Share Follow See all 0 reply Please log in or register to add a comment.