dbTalk Databases Forums  

Definition Needed: "proper superkey"

comp.databases.theory comp.databases.theory


Discuss Definition Needed: "proper superkey" in the comp.databases.theory forum.



Reply
 
Thread Tools Display Modes
  #21  
Old   
-CELKO-
 
Posts: n/a

Default Re: Definition Needed: "proper superkey" - 08-04-2008 , 04:10 PM






Quote:
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?



Reply With Quote
  #22  
Old   
-CELKO-
 
Posts: n/a

Default Re: Definition Needed: "proper superkey" - 08-04-2008 , 04:10 PM






Quote:
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?



Reply With Quote
  #23  
Old   
-CELKO-
 
Posts: n/a

Default Re: Definition Needed: "proper superkey" - 08-04-2008 , 04:10 PM



Quote:
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?



Reply With Quote
  #24  
Old   
-CELKO-
 
Posts: n/a

Default Re: Definition Needed: "proper superkey" - 08-04-2008 , 04:10 PM



Quote:
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?



Reply With Quote
  #25  
Old   
-CELKO-
 
Posts: n/a

Default Re: Definition Needed: "proper superkey" - 08-04-2008 , 04:10 PM



Quote:
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?



Reply With Quote
  #26  
Old   
-CELKO-
 
Posts: n/a

Default Re: Definition Needed: "proper superkey" - 08-04-2008 , 04:10 PM



Quote:
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?



Reply With Quote
  #27  
Old   
-CELKO-
 
Posts: n/a

Default Re: Definition Needed: "proper superkey" - 08-04-2008 , 04:10 PM



Quote:
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?



Reply With Quote
  #28  
Old   
-CELKO-
 
Posts: n/a

Default Re: Definition Needed: "proper superkey" - 08-04-2008 , 04:10 PM



Quote:
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?



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.