Yes exactly, except the color id is a numeric id taken from the colors table, although you can reduce the level of normalization depending on the amount of items you'll manage, so you might not need color and size tables.

>Hi,
>Thank you for reply.
>
>Do you meant that, your item records may look like this?
>
>

>ItemID                ColourID              SizeID               ClassID
>00001                 RED                   56                   A
>00001                 YELLOW                56                   A
>00001                 BROWN                 56                   A
>
>

>There will be 3 item records with same itemid but may be diff colourID, classid and sizeid?
>
>Thank you