title: What are the ways to model multivalued M : N relationship?
body: <p>I am working on the project that requires multivalued M : N relationship.</p>
  
  <p>For eg. 
  There is a list of products in the <code>Products</code> table.
  The user can purchase 1 or more products and are maintained in the table <code>Orders</code>. Along with this information, there is one more table that maintains analytical information. </p>
  
  <p>This table should contain the hard coded data like. If the order contains product 1 and product 2 then does product 3 and product 4 also appeared in the user's order. These are basically hard coded rules</p>
  
  <pre><code>actual products | expected products
  1,3             | 2,4
  5,6,7,8         | 3,4
  </code></pre>
  
  <p>Now from these tables, I need to find information like if user's order number 1 had products like 1 and 3 then return 2 and 4.</p>
  
  <p>I need suggestions as to how to describe this multivalued M to N relationship. If there are any other options other than RDBMS feel free to suggest. Thanks</p>