Results 1 to 5 of 5
  1. #1
    Join Date
    Jun 2012
    Posts
    3

    Unanswered: category / other table

    i have a table here
    something like this

    table :
    size
    Code:
    size id size name 
           1            S
           2            M
           3            L
           4            XL
           5            XXL
    but i am confused when i found that the size must have any category i mean something like.

    cloth_size ,pant_size, sheets_size

    that would be different ,

    row will be 6XL , 5XL, 4XL

    i think should i crate the table like

    table :
    sheets_size

    Code:
    size id size name 
           1            S
           2            M
           3            L
           4            XL
           5            XXL
    or should i create the table like
    table category

    Code:
    category_id category_name
                  1              cloth
                  2              dress
                  3              pants
                  4              sheets
    table :
    size

    Code:
    size id size name           category
           1            S            1
           2            M           1
           3            L            1
           4            XL          1 
           5            XXL        4
    which one better???

    i will be appreciate about your answer

  2. #2
    Join Date
    Jun 2012
    Posts
    3
    bump bump bump bump

  3. #3
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    Quote Originally Posted by shiningstone View Post
    bump bump bump bump
    you are bumping a threads after 6 minutes, I suspect you have unreasonable expectations of this site, or for that matter a site where you pay for advice/assistance

    if your size types are specific to a types of garment then you probably do need to sub classify by garment type

    obviously it must be so for shoe sizes compared to say shirts
    you may also need to sub classify by country

    ferisntance there are at least 3 shoe sizes I can think of, some clothes are sized in metric, imperial or US.

    there are also different sizing schemas for what is ostensibly the same type of garment (eg some may size S,M,L....?XL soem may size with a measurement)

    there are different sizing schemas between men, women & children.

    also you need to bear in mind that some garments may have more tan one metric eg trousers could have waist + leg length.
    a (mens) suit may have chest, waist + leg length.
    I'd rather be riding on the Tiger 800 or the Norton

  4. #4
    Join Date
    Jun 2012
    Posts
    3
    Quote Originally Posted by healdem View Post
    you are bumping a threads after 6 minutes, I suspect you have unreasonable expectations of this site, or for that matter a site where you pay for advice/assistance

    if your size types are specific to a types of garment then you probably do need to sub classify by garment type

    obviously it must be so for shoe sizes compared to say shirts
    you may also need to sub classify by country

    ferisntance there are at least 3 shoe sizes I can think of, some clothes are sized in metric, imperial or US.

    there are also different sizing schemas for what is ostensibly the same type of garment (eg some may size S,M,L....?XL soem may size with a measurement)

    there are different sizing schemas between men, women & children.

    also you need to bear in mind that some garments may have more tan one metric eg trousers could have waist + leg length.
    a (mens) suit may have chest, waist + leg length.
    thanks for answer, i am so glad to see this, mr healdem,

    yes, in my expectation, the category must be specific, men, women & children. etc , but the client want it dynamically, i mean, client want it with free - type . client want to input the type at their will .

  5. #5
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    well then the client needs direction
    the client needs informing that if they want their stock to be searchable based on size or other criteria then they need to understand that they are talking (*^&(*^. they may well know retail or wholesale, but they know stuff all about systems design

    they need to understand why you use the relational part of relational integrity
    they need to understand the chaos they will cause if they allow free form text entry of sizes
    they need to sign a piece of paper that can be used in evidence when they realise the error of their ways.
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

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