Register

Minimization of ER diagram

869 views
0 votes
0 votes
What is the minimum no tables required if relationship between two strong entity has total participation at one end with mapping as 1:1 ?

I see solution in many questions as 1 table required but I think it should be 2 tables as until total participation is at both ends of relationship we cannot combine into 1 table.

Please suggest whether my understanding is correct or not?
User Avatar

1 Answer

1 votes
1 votes
I AGREE WITH YOU ON THIS POINT .IF THERE IS 1:1 RELATIONSHIP WITH TOTAL PARTICIPATION AT ONE END THEN MINIMUM 2 TABLE WILL BE NEEDED AND IF BOTH SIDE ARE IN FULL PARTICIPATION THEN 1 TABLE WILL BE NEEDED AND IF MAXIMUM TABLE IS ASKED THEN 3 TABLE WILL BE NEEDED.
User Avatar
Voting & Accepting an answer helps improve the community
← PreviousNext →
← Previous in categoryNext in category →

Related questions

0 votes
0 votes
0 answers
1
Shrenik Pradhan asked Nov 16, 2023
206 views
https://www.javatpoint.com/dbms-reduction-of-er-diagram-into-table
How can I represent the ER model in tabular form? , in java point, the tabular form doesn't seem to be correct. Ref. https://www.javatpoint.com/dbms-reduction-of-er-diagram-into-table
How can I represent the ER model in tabular form? , in java point, the tabular form doesn't seem to be correct.Ref. https://www.javatpoint.com/dbms-reduction-of-er-diagra...
User Avatar
2 votes
2 votes
3 answers
4
daksirp asked Apr 23, 2022
1,351 views
ER Diagram: What is the cardinality of this relationship? is m-n cardinality correct? if not, why?
What is the cardinality of this relationship? is m-n cardinality correct? if not, why?
What is the cardinality of this relationship? is m-n cardinality correct? if not, why?
User Avatar
Link Copied!