Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
Database Servers
DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybase
Desktop Databases
FileMakerFoxProMS AccessParadox
General
General DB TopicsDatabase Theory
Related Topics
Java Development.NET DevelopmentVB DevelopmentMore Topics ...

Database Forum / General DB Topics / DB Theory / August 2008

Tip: Looking for answers? Try searching our database.

Definition Needed: "proper superkey"

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Gene Wirchenko - 24 Jul 2008 01:47 GMT
I can not find a definition for "proper superkey".  I have found
"superkey", but not "proper superkey".

Sincerely,

Gene Wirchenko

Computerese Irregular Verb Conjugation:
    I have preferences.
    You have biases.
    He/She has prejudices.
Gene Wirchenko - 24 Jul 2008 01:49 GMT
>     I can not find a definition for "proper superkey".  I have found
>"superkey", but not "proper superkey".

    Belay that.  I misread "proper superset" as "proper superkey".

Sincerely,

Gene Wirchenko

Computerese Irregular Verb Conjugation:
    I have preferences.
    You have biases.
    He/She has prejudices.
David Portas - 24 Jul 2008 06:59 GMT
>     I can not find a definition for "proper superkey".  I have found
> "superkey", but not "proper superkey".
[quoted text clipped - 7 lines]
>     You have biases.
>     He/She has prejudices.

"A superkey that does not have the irreducibility property; i.e., a proper
superset of a key."

- The Relational Database Dictionary

Signature

David Portas

-CELKO- - 04 Aug 2008 22:10 GMT
>>   I can not find a definition for "proper superkey".  I have found "superkey", but not "proper superkey". <<

I never heard that one either. So, I will make a wild guess :)

Some superkeys are keys with extra columns tacked on the end which can
be tirmmed -- (vin, assigned_parking_space). You might use it to get a
covering index.

Some superkeys have several subsets which are candidate keys -- given
Schedule (teacher, room_nbr, class_period), we could make all three
columns into the key, but (room_nbr, class_period) -> teacher  and
(teacher, class_period) -> room_nbr which gives us other, smaller keys
and no rule for picking which one to use.

Maybe a "proper superkey" is one of these situations?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.