= 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], discount_percentage, type)

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, product_id*[PRODUCT]?????, title, release_date, genre, record_label, cover_photo)

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_used, points_earned)

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, discount)
}}}


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

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

== Relational diagram