= Relational Design

==== Notation:
* **Primary keys** - underlined with bold lettering
* **Foreign keys** - marked with a * after the key name
* **Required attributes** - bold lettering

== Tables

{{{#!div style="text-align: justify; width: 100%;"

1. USER (**__user_id__**, **username**, **email**, **password**, **date_created**, shipping_address, telephone_number)

2. ADMIN (**__user_id*__**[USER], **type**, **discount_percentage**)

3. CONSUMER (**__user_id*__**[USER], **points_collected**)

4. WISHLIST (**__wishlist_id__**, **__user_id*__**[USER])

5. PRODUCT (**__product_id__**, **price**, **format**, **description**, **stock**)

6. RELEASE (**__release_id__**, **title**, **release_date**, **genre**, **cover_photo**, record_label)

7. ALBUM (**__release_id*__**[RELEASE])

8. SINGLE (**__release_id*__**[RELEASE], **duration**)

9. SONG (**__song_id__**, **song_name**, **duration**)

10. ORDER (**__order_id__**, **__user_id*__**[USER], **purchase_date**, **status**, **payment_method**, **points_earned**, points_used)

11. ORDER_ITEM (**__order_id*__**[ORDER], **__product_id*__**[PRODUCT], **quantity**, **price_at_purchase**)

12. ARTIST (**__artist_id__**, **artist_name**, photo, description)

13. MODIFICATION (**__modification_id__**, **__user_id*__**[ADMIN], **date_modified**, **type_of_modification**, discount)
}}}


==== DDL script for creating the database schema and objects:

==== DML script for filling tables with data:

== Relational diagram