How do we manage many-many relationships ? In HFEJB, we have only examples of one-one, one-many and many-one?
In database terms, we resolve it by having an XRef table, that has relationships of one-many and many-one. For example: Actor(0..m) <- -> (0..n) Movies (1) An Actor has worked in many movies. (2) A Movie has many actors.
At database end, we will have an Actor_Movie table in addition to the above two tables. So we will have the following resolved relationships Actor [0..1] [0..m] Actor_Movie [0..n] [0..1] Movie