2

Is it possible to have more than n candidate keys in table of n columns? I know that i can have exactly n candidate keys f.e. in table where every piece of every record is different. But how about more candidate keys?

Mike Sherrill 'Cat Recall'
  • 91,602
  • 17
  • 122
  • 185
Jac Mos
  • 7,746
  • 4
  • 15
  • 21

1 Answers1

2

No.

You can have compound keys. So if there are n simple keys then table can have 2^n - 1 superkeys. But since candidate key is minimal superkey, there can be only n candidate keys.

Anurag Peshne
  • 1,547
  • 12
  • 29