| |
|
If this is your first visit, be sure to check out the FAQ by clicking the link above.
You may have to register before you can post: click the register link above to proceed.
To start viewing messages, select the forum that you want to visit from the selection below.
|
 |
|

03-17-06, 11:52
|
|
Banned
|
|
Join Date: Mar 2006
Posts: 20
|
|
|
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
|
|

03-17-06, 11:55
|
|
Purveyor of Discontent
|
|
Join Date: Mar 2003
Location: The Bottom of The Barrel
Posts: 6,075
|
|
do I get the college credit if I give you the answers?
|
|

03-17-06, 11:58
|
|
Banned
|
|
Join Date: Mar 2006
Posts: 20
|
|
|
|

03-17-06, 12:08
|
|
Banned
|
|
Join Date: Mar 2006
Posts: 20
|
|
|
|

03-17-06, 12:15
|
|
World Class Flame Warrior
|
|
Join Date: Jun 2003
Location: Ohio
Posts: 11,726
|
|
__________________
If it's not practically useful, then it's practically useless.
blindman
www.chess.com: "sqlblindman"
|
|

03-17-06, 12:16
|
|
Banned
|
|
Join Date: Mar 2006
Posts: 20
|
|
I was looking for an answer to my question, not a smart ass response. Thanks
|
|

03-17-06, 12:22
|
|
World Class Flame Warrior
|
|
Join Date: Jun 2003
Location: Ohio
Posts: 11,726
|
|
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"
|
|

03-17-06, 12:23
|
|
Banned
|
|
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
|
|

03-17-06, 12:26
|
|
World Class Flame Warrior
|
|
Join Date: Jun 2003
Location: Ohio
Posts: 11,726
|
|
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"
|
|

03-17-06, 12:29
|
|
Banned
|
|
Join Date: Mar 2006
Posts: 20
|
|
Thanks for nothing loser!
I would rather fail then get your help!
|
|

03-17-06, 12:29
|
|
Banned
|
|
Join Date: Mar 2006
Posts: 20
|
|
Oh yeah [obscenity removed], while your at it 
|
|

03-17-06, 12:34
|
|
Banned
|
|
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 
|
|

03-17-06, 12:36
|
|
World Class Flame Warrior
|
|
Join Date: Jun 2003
Location: Ohio
Posts: 11,726
|
|
Quote:
|
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"
|
|

03-17-06, 12:41
|
|
Banned
|
|
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 13:02.
|

03-17-06, 12:42
|
|
Banned
|
|
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 13:02.
|
| Thread Tools |
Search this Thread |
|
|
|
| Display Modes |
Linear Mode
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
|
|