March 3rd, 2012, 07:09 AM
ER Diagram for Online Shop
I've created simple ER diagram for the online shop. This diagram assumes that user can rate an item that they haven't bought.
I have to amend the diagram, so the user can only rate items that they have purchased.
Currently I have two separate relationships between User and Item: 'Rates' and 'Buys', where buys relationship have two conditions: Price and date.
Please suggest a way to amend my diagram accordingly.
Help is much appreciated.
March 3rd, 2012, 04:12 PM
make 'rates' a child of 'buys'
Originally Posted by nub1984