Given two tables Student(id,name) and course(course_id,course_name). Of course these two tables have M:N relationship. Is there any way to implement M:N relationship in relational database without using junction table? If not in relational database then in any other database model?

Please reply...
Thanks

There are ways to do that, but they are ugly and limiting. I hope you are considering just in theory, and not in practice.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.