Saturday, 23 April 2016

How to describes a Junction table ?


What would best describe the ORDER_PRODUCT table ?
 






















  • ORDER_PRODUCT table is Junction table.
  • It allows a many-to-many relationship between PURCHASE_ORDER and PRODUCT.
  • The table may contain multiple different "order_id" for a given "product_id"
 

No comments:

Post a Comment

Note: only a member of this blog may post a comment.