Interested to Buy Any Domain ? << Click Here >> for more details...
How to resolve many to many relationship?
- 6 Answers
- 36298 Views
- InfoAxon Technologies, Protech, Samsung, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / balaji
An example of a many-to-many relationship in the greenhouse
plant application is between the Plant and Additive
entities. Each plant may be treated with one or more
Additives. Each Additive may be given to one or more Plants.
The ERD for this relationship is shown below.
Many-to-many relationships cannot be directly converted into
database tables and relationships. This is a restriction of
the database systems, not of the application. The
development team has to resolve the many-to-many
relationship before it can continue with the database
development. If you identify a many-to-many relationship in
your analysis meeting, you should try to resolve it in the
meeting. The participants can usually find a fitting entity
to provide the resolution.
To resolve a many-to-many relationship means to convert it
into two one-to-many, many-to-one relationships. A new
entity comes between the two original entities, and this new
entity is referred to as an intersection entity. It allows
for every possible matched occurrence of the two entities.
Sometimes the intersection entity represents a point or
passage in time.
The Plant-Additive many-to-many relationship above is
resolved in the following ERD diagram:
With these new relationships, Plant is now related to
Treatment. Each Plant may be given one or more Treatments.
Each Treatment must be given to one and only one Plant.
Additive is also related to Treatment. Each Additive may be
used in one or more Treatments. Each Treatment must be
comprised of one and only one Additive. With these two new
relationships, Treatment cannot exist without Plant and
Additive. Treatment can occur multiple times, once for each
treatment of a plant additive. To keep each Treatment
unique, a new attribute is defined. Treatment now has
application date and time attributes. They are the unique
identifiers or the primary key of Treatment. Other
attributes of Treatment are quantity and potency of the
additive.
| Is This Answer Correct ? | 41 Yes | 3 No |
Answer / kelvin omondi
resolving a many to many relationship requires the use of a
new table known as the associative entity
| Is This Answer Correct ? | 34 Yes | 4 No |
Answer / arvind
By introducing a new entity known as intersection or associate entity between them
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / kirankumar
when the many to many relation ship occur means when the foreign key having one table ,another table also having foreign key at that time having many to many relation ship.but two foreign keys cannot connect directly ,buy using the bridge table you can connect the two foreign keys,buy using the brigtable u can resolve the many to many relationship.
any rdbms cannot support many to many relationship
| Is This Answer Correct ? | 3 Yes | 3 No |
Answer / praveen kumar
There are 4 kinds of relationships
1.Dependancy
2.Association
3.Generalization
4.Realization
| Is This Answer Correct ? | 6 Yes | 23 No |
Explain the use of Vtable and what are the various problems to override the functions?
Can we override a method by using same method name and arguments but different return types?
What is multiple inheritance? How java 8 supports multiple inheritance?
Can a function be overloaded based on return types?
What do you mean by polymorphism?
0 Answers InterGraph, Ittiam Systems,
What is serialization? How do we implement serialization actually?
What is an interface?
What is the difference between a virtual method and an abstract method?
What is the difference between new and override?
Can you instantiate an abstract class and what is an inner class?
0 Answers Flextronics, Tavant Technologies, Virtusa,
State two differences between an object and a class.
What is an USECASE? Why it is needed?
Design Patterns 
