> I don't know how to check if I've gotten it right or wrong.
There is no 'right' or 'wrong' way to normalize - it's like asking a room full of economists a question.
You need to read everything you can, and ask others opinions. You are welcome to post your table definitions here, or send them to me, and I will take a look.
Wayne Myers, MCSD
Senior Consultant
Forte' Incorporated
"The only things you can take to heaven are those which you give away" Author Unknown