Organizational Research By

Surprising Reserch Topic

superkey candidate key primary key

superkey candidate key primary key  using -'sql,oracle,primary-key,relational,candidate'

can any kind soul clarify my doubts with a sample example below for the superkey, candidate key and primary key.
I know there are alot of posts and websites out there explaining what's the differences between them. But it looks like all are generic definition.

Below shows my following example:

Student (StudentNumber, FamilyName, Degree, Major, Grade, PhoneNumber)

So from the above example, I can know StudentNumber confirm is a primary key.

But as for superkey, i'm abit confused of which are the combination of attributes. Which are the attributes that could be grouped into the superkey?

As for candidate key, i'm confused by the definition given as any candidate key can be qualify as a primary key.
Is it meaning that attributes such as phonenumber is a candidate key and can be a primary key? (Assuming that a phonenumber only belongs to one student)  

Thanks for any clarification!

asked Sep 9, 2015 by MarS25
0 votes

Related Hot Questions

3 Answers

0 votes
answered Sep 9, 2015 by LuizHTWYihln
0 votes
answered Sep 9, 2015 by StacieNisbet
0 votes
answered Sep 9, 2015 by ArdenClevela