Register

Minimization of ER diagram

1,100 views
0 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?

1 Answer

1 1 vote
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.
Voting & Accepting an answer helps improve the community
← Previous · SELF DOUBTNext → · NFA OR DFA??
← Previous in category · self doubts[ join]Next in category → · SQL Query
Position:
Show:

Related questions

1 1 vote
2 2 answers
704
704 views
Swapnil Ganguly_1 asked Jan 22
704 views
Minimum number of relations from ER Diagram which satisfy BCNF
0 0 votes
0 0 answers
708
708 views
Shrenik Pradhan asked Nov 16, 2023
708 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-diagra...
1 1 vote
1 1 answer
1.1k
1.1k views
rexritz asked Aug 29, 2023
1,091 views
Finding minimum number of tables needed to represent ER diagram
Find minimum number of tables needed to represent following ER diagram?This question would have been relatively simple as we would implicitly convert the ERD to 3NF (aske...
0 0 votes
1 1 answer
1.2k
1.2k views
Pradeep_Kumar asked Jul 13, 2023
1,227 views
Confused about cardinality of ER diagram which one is whose cardinality ,look on my notes and clear it out.