What Is Super Key in Dbms

Only available on StudyMode
  • Download(s) : 297
  • Published : October 18, 2010
Open Document
Text Preview
What Is Super Key In Dbms?
Superkey - A superkey is defined in the relational model as a set ofattributes of a relation variable (relvar) for which it holds that inall relations assigned to that variable there are no two distincttuples (rows) that have the same values for the attributes... in Software

What Is Super Key In Dbms Give Example?
A superkey is a combination of attributes that can be uniquely used to identify a database record.With primary key if any other attribute is added then that combination is called super key in other words,primary key is the minimum possible... in SQL & Databases

What Is The Primary Key, Super Key, Foreign Key And
http://www.blurtit.com/search/?query=What+Is+Super+Key+In+Dbms%3F&st=rk&cid=9673591489&page=q152488.html

http://www.blurtit.com/q152488.html

Superkey - A superkey is defined in the relational model as a set of attributes of a relation variable (relvar) for which it holds that in all relations assigned to that variable there are no two distinct tuples (rows) that have the same values for the attributes in this set. Equivalently a superkey can also be defined as a set of attributes of a relvar upon which all attributes of the relvar are functionally dependent.

For example, the bank account number
is a super key in the bank accounts table.

What Is Super Key In Dbms?

Ads by Google
• Database Management
WinSQL - A Homogeneous Solution for Heterogeneous Environment. www.synametrics.com
• Database compression
Higher compression ratio. Faster operation. Transparency. Pick any 3 www.xtremecompression.com
• 9i, 10g Tuning
and monitoring w/ Lab128 - a must have for DBAs and senior developers www.lab128.com
• Access Control
Electronic Lock & Key based Access Control System
www.intellikey.com

[pic][pic][pic][pic][pic][pic]Find Answers for: What Is Super Key In Dbms?

[pic]
1
 
Superkey - A superkey is defined in the relational model as a set of attributes of a relation variable (relvar) for which it holds that in all relations assigned to that variable there are no two distinct tuples (rows) that have the same values for the attributes in this set. Equivalently a superkey can also be defined as a set of attributes of a relvar upon which all attributes of the relvar are functionally dependent.

For example, the bank account number
is a super key in the bank accounts table.

Hope It Helps

Great Answer Not Helpful Report
Rinav 2 years ago
Ads by Google
• Access Control
Electronic Lock & Key based Access Control System
www.intellikey.com
[pic][pic][pic][pic][pic][pic]
0
 
A Super Key is a of attributes that collectively identify a entity in a entity set. For example, the bank account number is a super key in the bank accounts table.

From Malaysia
Great Answer Not Helpful Report
Guest 2 years ago
Ads by Google
• Accelerate cloud storage
performance by 100 fold and access it like a normal harddrive www.clouddrive.com.au
[pic][pic]
0
 
If we add additional attribute to a primary key the resulting combination would still uniquely identify as instance of entity set, this augumented key are called super key Eg. Roll no and name
Great Answer Not Helpful Report
Guest 1 year ago
[pic]
0
 
Explain primary and super key clearly
Great Answer Not Helpful Report
Ramyamuthu 3 months ago
[pic]
0
 
A column or set of columns that uniquely identifies a row within a table. Great Answer Not Helpful Report
Anantv10 10 months ago
Ads by Google
• InDesign DB Publishing
EasyCatalog™ - a complete database publishing solution www.65bit.com
[pic][pic]
0
 
An attribute or a sets of attribute that uniquely identified an entity in the entity type called a  super key. Great Answer Not Helpful Report
Guest 10 months ago
[pic]
0
 
Use of the super key
Great Answer Not Helpful Report
Guest 9...
tracking img