Big question on relationships

[Anonymous]

Imagine you have a many to many relationship as:

Student <-> Course

Whem I use CMR fields I get a relation table like:

RELATIONSHIP_STUDENT_COURSE (ID_STUDENT, ID_COURSE)

And I will have methods like course.addStudent and student.addCourse in each EntityBean.

BUT if I need to add more information about this relationship like a date or something else. How can I add that information?

[Jeanne Boyarsky]

F�bio,
Create a table/ejb to link the too.

So you would have a relationship between studentid and newTableId. Then another relationship between newTableId and courseId.

[Adeel Ansari]

yes, we must have a reference table between two tables having many-to-many relationship.

please tell me if i am wrong.