silentbeautybalaji (10/7/2013)
can anyone help me for which columns primary columns is need.
My guess is that data modeling for this project is half cooked - at best.
Do you have an E/R model?
Either way, when selecting a Primary Key, a Natural PK I should add, you should ask yourself; "What column/s in this table uniquely identify a member of this entity?"
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.