Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.

share|improve this question

closed as too broad by RolandoMySQLDBA, Paul White, Max Vernon, Michael - sqlbot, Kin Feb 20 '14 at 14:32

There are either too many possible answers, or good answers would be too long for this format. Please add details to narrow the answer set or to isolate an issue that can be answered in a few paragraphs.If this question can be reworded to fit the rules in the help center, please edit the question.

up vote 0 down vote accepted
  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
share|improve this answer
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" – Stoan 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. – Stoan Feb 27 '14 at 6:18

Not the answer you're looking for? Browse other questions tagged or ask your own question.