Changes between Version 17 and Version 18 of ERModel


Ignore:
Timestamp:
05/04/26 03:43:07 (2 days ago)
Author:
231241
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • ERModel

    v17 v18  
    125125
    126126[attachment:ERModel_v01.png Version 1]
    127 
     127* Initial Version
    128128[attachment:ERModel_v02.png Version 2]
    129 
     129* Removed number_of_tracks attribute from Album
     130* Removed purchase_history from Consumer
     131* Changed contains relation Album ↔  Song from 1:N to M:N
     132* Changed creates relation User ↔  Order 1:1 to 1:N
     133* Changed refers relation WishlistItem ↔  Product from N:1 to N:M
    130134[attachment:ERModel_v03.png Version 3]
    131 
     135* Implemented features relationship between Song ↔ Artist and Single ↔ Artist to replace the featured_artist multi-valued attribute.
     136* Removed create relationship between  Admin ↔ Product and implemented a new entity Modifcation, with relationships perform and refers, to allow creation and modification of products by admins.
     137* Moved attributes from Consumer to User and made it overlap instead of disjoint, to allow Admins to be able to purchase Products for testing and recreational purposes.
     138* Added discount_percentage attribute to Admin, and points_used and points_earned to Order.