Click here to Skip to main content
15,891,757 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi all,

I am doing some revision for a database module and I have come across this question in a past paper:

Identify all the superkeys in the following table:

ID First name Last name Age
1 Sean O'Connor 22
2 Tim O'Connor 27
3 Jack Black 32
4 Jack Coventry 3
5 Natalie Spifflington 27


Now the answers say that the super keys are:
{Employee Number, FirstName, LastName, Age}
{FirstName, LastName, Age}
{FirstName, LastName}
{Employee Number}

My question is why isn't say (lastname, age) a superkey? As far as I have understood superkeys there is no tuple of lastname, age that has two different entries.

Thanks in advance to anyone who can offer some insight.
Posted

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900