posted 17 years ago
Dear friends,
Can anybody tell me a real life scenario where one would need a unique key?
As far as my understanding of Normalization goes, i would not need a unique key if my tables are properly normalized. Because if i am having a unique key (There would always be a primary key), then the data in my table would not depend on a single column. So i need to normalize my table untill all the data is dependent upon one single column. And this will remove any possibility of having unique key in my table.
Please correct me if i am wrong.
Thanks in advance