0

I don't have much experience designing databases, I'm looking for some advice on my design from more seasoned designers/developers. I'm developing a digital content eCommerce store which will be desktop based and mobile based similar to iTunes.

Schema Schema Design

The store will most work like iTunes, it's just that it's focused on music at the moment. I'm not sure if I should explain each table responsibility. Users can reload monetary credits to their profiles from an external application.

Please advice if this design will work and is sufficient. Thank You.

Siya Stoan Sosibo
  • 113
  • 2
  • 8

1 Answers1

0

  1. Get yourself a good data model pattern book.

  2. Accept the fact that most relationships are many-to-many.

  3. Read up on table inheritance and the Party/Party Role model.

Some starting points:

  1. An order has many line items, which belong to a product
  2. A product will probably belong to multiple categories
  3. A product will likely have more than one artist
Community
  • 1
Neil McGuigan
  • 8,423
  • 4
  • 39
  • 56
  • Thanks for giving me direction. :-)

    Can you please elaborate on this point further, im not if I understand you "An order has many line items, which belong to a product"

     – Siya Stoan Sosibo Feb 19 '14 at 18:15
  • Well, someone might buy a few items in a single order. You probably want to encourage this in fact. So there could be many line items for a given order. A line item is for a product quantity at a given unit price. – Neil McGuigan Feb 19 '14 at 18:43
  • I guess this makes sense for billing purposes and physical good where user might buy more than one quantity.

    But here it's a digital content store, so the user will be buying just one item in terms of quantity always. It doesn't have a cart as well, as soon as the user clicks the "Buy Now" button, I want to complete the transaction, basically bill the user and start the download.

     – Siya Stoan Sosibo Feb 27 '14 at 06:18