Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2011
    Location
    Long Beach, CA
    Posts
    3

    Question Unanswered: Database Model Schema for Retail Sporting Goods Store

    See anything wrong with this model.

    Any help would be appreciated.
    Attached Thumbnails Attached Thumbnails database_model.gif  

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    yeah, i see plenty

    for starters, it's hard to read

    upon closer inspection, i don't understand what's going on

    say, what software did you use to produce this?
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Jan 2011
    Location
    Long Beach, CA
    Posts
    3

    Need to send a new graphic

    Only half of the image was uploaded. I will update the graphic tomorrow.

    Basically another set of tables is used to categorize the products in the TaxId field.

    basically its like this:

    CatId PK
    Cat_Name

    CatId FK
    SubCatId PK
    SubCatName
    Order

    SubCatId FK
    ClassId PK
    ClassName
    Order

    ClassId FK
    ProdId PK
    ProdName
    Order

    ProdId is PK to the FK TaxId Products Table in the graphic posted.

    I used Adobe Illustrator because its gonna be used to show people that don't have a web development background.

    If this makes no sense then sorry :P
    Last edited by buildingbrick; 01-24-11 at 21:51.

  4. #4
    Join Date
    Jan 2011
    Location
    Long Beach, CA
    Posts
    3

    Database Model Schema for Retail Sporting Goods Store

    I created this database model for a sporting goods store. Its not ecommerce.

    If anyone can take a look and let me know if anything looks wacky.

    Please let me know.
    Attached Thumbnails Attached Thumbnails database_model.jpg  

Tags for this Thread

Posting Permissions

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