adspace


What is the physical representation for a many-to-many relationship?

Answer Posted / Anjali Devi

A many-to-many relationship between two tables can be physically represented in three ways: 1) Using a junction table (associative entity) with foreign keys to both original tables. 2) By embedding one-to-many relationships in each of the original tables as self-referential foreign keys. 3) Through inheritance, where one or more intermediate tables are created to represent the relationship.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Hi , any one can help me on the same,this is regarding the Informatica Function doc,i want to know how developer is will develop the mapping. pl forwar the any function doc .just for my references. svlc75@yahoo.co.in

2107