Whats the use of super keys and candidate keys when primary key can handle the entire thing in database?????

You need to read books for all those details.

If they were not necessary, you wont hear of them. Am sure you're reading and that's why you knew of them, just keep reading

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.18 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.