Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2003
    Posts
    163

    Unanswered: Sample data required

    Sample data required


    Hello.

    Though this is not directly a SQL related question but I could not think of some other forum to post this request. <y

    apologies if I should have posted elsewhere...


    I need some sample data for a departmental store (like WalMart of KMart) which sell a wide variety of things and probably

    everything under the sun

    I need data in such a manner that we have 4-5 levels of data hierarchy. For example we can have a data hierarchy like

    follows:

    Classification
    Category
    Sub Category
    Product Group
    Item


    The above is just an example but I hope that most of you already know what I neeed. An example of data based on the following

    hierarchy can be as follows (shown in a tabular manner)


    Classification | Category | Sub Category | Product Group | Item
    ---------------------------------------------------------------
    Household Items| Electronics| Entertainment| Audio| SONY Room entertainment box, 2 speakers 300 W each, ....
    Household Items| Electronics| Entertainment| Audio| Phillips Boom Box, ...specifications....
    Household Items| Electronics| Entertainment| Video| SAMSUNG DVD Player model SG-17X5 ...
    Household Items| Electronics| Entertainment| T.V | SONG TRINTORN 51" .....
    ...
    ...

    Groceries | Drinks | Colas| Coke | COke 12-Pack Cans ....
    Groceries | Drinks | Colas| Coke | COke 2.25 Litre Jumbo Pack..
    Groceries | Drinks | Colas| PEPSI| PEPSI 2.25 Litre Jumbo Pack..
    .....
    ...

    Toys | Girls | Dolls| Barbie | Barbie princees model A21 ..
    ...
    ..



    I hope the above provides you with a clear understanding of my requirement.

    I'll be extremely grateful for your help.

    Thanks & Regards.

  2. #2
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    You only need a conceptual hierarchy. Interestingly all you need to start this excersise is 1 table with 1 identity column. Generate as many numbers as you can (10K is usually enough) and start forming SQL statements to populate other tables that will be serving the roles of Classification, Category, Sub-Cat, Prod Group, and Item. Then, if in SQL2K5 environment, - review WITH... construct to perform your testing.
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  3. #3
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by Joozh
    I hope the above provides you with a clear understanding of my requirement.
    you were doing a brilliant job making up the sample data yourself

    just keep going

    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  4. #4
    Join Date
    Oct 2003
    Posts
    163

    Smile

    Quote Originally Posted by r937
    you were doing a brilliant job making up the sample data yourself

    just keep going

    Thanks but it was turning out to be quite an effort and therefore I was wondering if there some where (out there in the w w w space) from where I can get sample data

    Regards.

Posting Permissions

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