posted 15 years ago
Can an associative entity be used between 2 entities that have a 1:many relationship? Or do must they only apply between a many:many..
The examples I can see online are about many:many
eg. a Grade entity between a Course and a Student...
I thinking about using an associative entity between what I originally considered as a 1:many relationship
i.e An Order has many Order Items...However, an audit history is required (of items being removed or added from the transaction).
So I want to use another entity to map the relationship between the orders and the ordered items...items could be added and removed several times..
I am sounding reasonable here? Or is this crazy talk?