Page 1 of 2 12 LastLast
Results 1 to 15 of 17
  1. #1
    Join Date
    Mar 2006
    Posts
    20

    Unanswered: Help me id candidate and superkeys please

    The relation (table) schema is multimedia (mm_id, f_name, extension, directory, size).

    1) Identify at least three super keys for the relation called ?multimedia?.
    2) Identify at least two candidate keys for the relation called ?multimedia?

    Thanks much

  2. #2
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    do I get the college credit if I give you the answers?
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  3. #3
    Join Date
    Mar 2006
    Posts
    20
    yes and a cookie

  4. #4
    Join Date
    Mar 2006
    Posts
    20
    come on, throw me a bone

  5. #5
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Tibia. Fibula. Ulna.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  6. #6
    Join Date
    Mar 2006
    Posts
    20
    I was looking for an answer to my question, not a smart ass response. Thanks

  7. #7
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    No, you were looking for help cheating on your exam. Ask a dumb-ass question, get a smart-ass response.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  8. #8
    Join Date
    Mar 2006
    Posts
    20
    How about this one:
    A B C
    a1 b1 c1
    a1 b1 c2
    a2 b1 c1
    a2 b1 c3

    Identify the superkeys.
    Identify the candidate keys
    Identify at least three functional dependencies

    I would seriously appreciate some honest help

  9. #9
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    The question doesn't make sense. A superkey is a password key that will unlock any encrypted table. A candidate key is a key that hopes to be elected to superkey, usually after running and winning a primary key.

    Functional Dependencies:
    1) Alcoholism.
    2) Compulsive gambling.
    3) Inability to answer one's own exam questions.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  10. #10
    Join Date
    Mar 2006
    Posts
    20
    Thanks for nothing loser!

    I would rather fail then get your help!

  11. #11
    Join Date
    Mar 2006
    Posts
    20
    Oh yeah [obscenity removed], while your at it

  12. #12
    Join Date
    Mar 2006
    Posts
    20
    Quote Originally Posted by blindman
    Tibia. Fibula. Ulna.
    I would love to meet you and break all of the above

  13. #13
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    I would rather fail then get your help!
    Your wish is granted.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  14. #14
    Join Date
    Mar 2006
    Posts
    20
    Quote Originally Posted by blindman
    I'm pretty sure he has no bones. What is the purpose of a spine without if you have no brain to support?
    Yeah, your right, you probably don't have one, you spineless piece of monkey [obscenity removed], .

    And smart guy read your statement again it makes no sense. Try 'it' instead of if you database loser!
    Last edited by blindman; 08-24-06 at 14:02.

  15. #15
    Join Date
    Mar 2006
    Posts
    20
    Quote Originally Posted by blindman
    Your wish is granted.
    Try again [obscenity removed], I got a 85 without your ghey forums help
    Last edited by blindman; 08-24-06 at 14:02.

Posting Permissions

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