2. Look into the following table- student_id name phone age 1 Akon 9876723452 17 2 Akon...

Transcribed Image Text:

2. Look into the following table- student_id name phone age 1 Akon 9876723452 17 2 Akon 9991165674 19 3 Bkon 7898756543 18 4 5 Ckon 8987867898 19 Dkon 9990080080 17 i) 11) Write down all the candidate keys, primary key and the secondary key in this table[3] Write down 2 superkeys in this table. [1] 2. Look into the following table- student_id name phone age 1 Akon 9876723452 17 2 Akon 9991165674 19 3 Bkon 7898756543 18 4 5 Ckon 8987867898 19 Dkon 9990080080 17 i) 11) Write down all the candidate keys, primary key and the secondary key in this table[3] Write down 2 superkeys in this table. [1]

Answer rating: 100% (QA)

Candidate keys are the minimal set of attributes that can uniquely identify each tuple in a t... View the full answer