how to identify which entity is child and which is parent...as in Movie OSMDb reactive web application we created a relation between Movie and MovieGenre .....Every movie should have a genre and different movies can have same genre.
How we can know Movie is child or parent entity.
Hi Eshita,
You seem to be describing a many-to-many relationship, where a movie can have multiple genres and the same genre can be present in multiple movies.
To support this scenario, there is no child nor parent relationship but a junction table that holds the relationship between genres and movies, something like the MovieGenre entity in my example below having a foreign key for the Movie and another foreign key for the Genre entities:
You can read more about creating many to many relationships in OutSystems here.
Hope it helps.
Cheers,João
Agree with João!
The theory is that:
In summary, it calls many to many relationship, you should add 1 more entity to keep the 2 attributes for a relationship between A and B. The example is mentioned in the answer above