Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2004
    Posts
    2

    Ecommerce Database Question

    I want to create an ecommerce database that can support multiple product types. Every article or tutorial I come across on the subject of ecommerce only deals with one type of product in the design which makes things simple.

    I am interested in creating a database that can support multiple product types such as music, apparel and misc. accessories. Each of these product types has it's own set of unique attributes. For example, music is associated with an Artist, a Genre, a Format (CD/Vinyl) and a Record Label. Apparel can have a Type (Shirt, Shoes), a size and a color.

    In what way can I create the appropriate database schema to treat each item as a generic product but yet associate the necessary attributes or options as needed.

    Thanks, Any help would be appreciated.

  2. #2
    Join Date
    Sep 2003
    Location
    The extremely Royal borough of Kensington, London
    Posts
    778
    Last edited by r123456; 07-23-04 at 03:23.
    Bessie Braddock: Winston, you are drunk!
    Churchill: And Madam, you are ugly. And tomorrow, I'll be sober, and you will still be ugly.

  3. #3
    Join Date
    Jul 2003
    Posts
    74
    This Data Model on the Database Answers web site answers your question by showing an example of Inheritance in Product Types for e-Commerce Games web site :-
    http://www.databaseanswers.org/data_...shop/index.htm

    B.Dimple
    DBA

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •