Results 1 to 4 of 4

Thread: candidate key

  1. #1
    Join Date
    Oct 2008
    Posts
    1

    candidate key

    Can a relation have the number of candidate keys greater than its attributes?

    Please give an example?

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    No relation of mine is a candidate for more keys than attributes, since only some relations get any key at all. My mother-in-law has many attributes but only one key.

    -PatP

  3. #3
    Join Date
    Oct 2008
    Posts
    8
    Ok, I now see how homework problems could be easy to spot.

  4. #4
    Join Date
    Dec 2007
    Location
    London, UK
    Posts
    741
    It may help you if you think about the edge cases.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •