search for: items_cart

...there seems to be a lot of promise except for one thing I can''t figure out as yet -- the above problem. Say I have the following conceptual relationships: ITEMS <<--->> CARTS i.e., each item can belong to one or more categories. So really we have ITEMS <<--> ITEMS_CARTS <-->> CARTS where the join table, items_carts, has the dual primary keys {items_id, carts_id}. However, in reality people can and will buy more than one of each item and so items_carts needs an additional attribute: quantity. My question is how might the above be defined as a migra...