Im not very database savvy either, so take this FWIW.
Basically i would design this with the name as the primary key. This would save things in 2 places. 1) You dont have to check duplicate in create, the DB does it for you.
2) Whjen u are associating a item to a itemgroup, you are going to reference it through a itemgroup name, not some integer key that maps to a number. You are avoiding a reference if u use the name as the primary key.
My 2 paisa worth!
Hi Raja, thanks for your reply.
I think I will do that, unless someone can shed a new light on it.