you dont want to store both the cat id and cat name in the products table.
you should only be storing the cat ID in the products table, this will create a relationship to the category name, to return the product information including the category name, you would use a join query:
sql_join.asp