Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

resolving many to many relatiionship

 
Yasir Qureshi
Ranch Hand
Posts: 44
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Dear Ranchers
We have a design of many to many relationship(lets say b/w/Table A and Table B) we resolve this into One to Many by including another table (lets say Table: AB) Now,
1) The data entered into Table AB is replicated to Table A & Table B.
2) The data is Entered into Table A then in Table then the data from Table A and Table B is replicated into Table AB .
which technique is more appropriate is there any pros or cons or both are write and same,which one should I use?
Yasir
SCJP2
 
Yasir Qureshi
Ranch Hand
Posts: 44
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
No reply yet
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic