Author: Sam73003 | Posted on: 6/30/2008 12:29:38 AM | Views : 329

� 

Lets say I

supplies 4 different types of product (A,B,C,D)my main objective is to capture rating( 20 types) of these different types of product in alphabet and also in numerical thru lookup table

I created following tables

Supplier( supplierid, supplier)01� ABC02� DEF....

Suppliertype( suppliertypeid, supplierid, typesof products)01� 01� A02� 01� B03� 01� C04� 01� D05� 02� A ........

I created thirdtable

Ratingtable(departmentid,suppliertype,rating)

Dept� 01� AAADept� 02� AADept� 03� AAA

� 

Am i on right track and beside that I also have to put numerical value for rating, where is the best place to add column for numerical rating?Can i add rating and numerical value to suppliertype table and taking off rating from rating table?

There are 20 types of rating with numerical value ( in look up table)
...

Go to the complete details ...