Results 1 to 2 of 2
  1. #1
    Join Date
    May 2004
    Posts
    1

    Question Best model for data

    Hi all,

    What is the best way of organizing this data? What are the benefits (in simple terms) and how can I implement these organizations in an opensource database?

    I want to create a database for a series of products, where the relevant data is:

    Product name 1 (Language 1)
    Product name 2 (Language 2)
    Product number
    Product description 1 (Language 1)
    Product description 2 (Language 2)
    Product applications 1 (Lang 1)
    Product applications 2 (Lang 2)
    Product image
    Product specifications (Lang 1)
    Product specifications (Lang 2)
    Product dimensions (Lang 1)
    Product dimensions (Lang 2)
    Further information (Lang 1)
    Further information (Lang 2)

    These may be accompanied by further languages.

    There are several hundred products, and there may be a large number of "miscellaneous" things that need a special category.

    The data is to be published using a parser for QuarkXpress.

    Thanks,
    P

  2. #2
    Join Date
    Dec 2003
    Location
    Canada
    Posts
    710
    Product(ProductNumber (PK), ProductImage)

    ProductDetail(ProductNumber (PKFK), LanguageID (PKFK),
    Description, Application, Specifications, Dimensions, Information)

    ProductDetailMisc(ProductNumber (PKFK), LanguageID (PKFK), MiscID (PK),
    MiscDescription)

    Language(LanguageID (PK), LanguageName)

    You have the product master and a row for each language in product detail. You also have a catchall for numerous adhoc entries in product detail misc.

Posting Permissions

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