GetWiki
superkey
ARTICLE SUBJECTS
being →
database →
ethics →
fiction →
history →
internet →
language →
linux →
logic →
method →
news →
policy →
purpose →
religion →
science →
software →
truth →
unix →
wiki →
ARTICLE TYPES
essay →
feed →
help →
system →
wiki →
ARTICLE ORIGINS
critical →
forked →
imported →
original →
superkey
please note:
- the content below is remote from Wikipedia
- it has been imported raw for GetWiki
{{Short description|Set of attributes that uniquely identifies each tuple of a relation}}{{about|the database design term|the keyboard button|Super key (keyboard button)}}In the relational data model a superkey is any set of attributes that uniquely identifies each tuple of a relation.WEB,weblink's-First-Two-Papers.pdf, Codd's First Relational Papers: A Critical Analysis, Date, Christopher, 2015, warwick.ac.uk, 2020-01-04, Note that the extract allows a ârelationâ to have any number of primary keys, and moreover that such keys are allowed to be âredundantâ (better: reducible). In other words, what the paper calls a primary key is what later (and better) became known as a superkey, and what the paper calls a nonredundant (better: irreducible) primary key is what later became known as a candidate key or (better) just a "key"., BOOK, Introduction to Database Management Systems, Tata McGraw-Hill, 77, 9780070591196, 2005, no two tuples in any legal relation, Because superkey values are unique, tuples with the same superkey value must also have the same non-key attribute values. That is, non-key attributes are functionally dependent on the superkey.The set of all attributes is always a superkey (the trivial superkey). Tuples in a relation are by definition unique, with duplicates removed after each operation, so the set of all attributes is always uniquely valued for every tuple. A candidate key (or minimal superkey) is a superkey that can't be reduced to a simpler superkey by removing an attribute.JOURNAL, Saiedian, H., 1996-02-01, An Efficient Algorithm to Compute the Candidate Keys of a Relational Database Schema,weblink The Computer Journal, en, 39, 2, 124â132, 10.1093/comjnl/39.2.124, 0010-4620, For example, in an employee schema with attributes employeeID, name, job, and departmentID, if employeeID values are unique then employeeID combined with any or all of the other attributes can uniquely identify tuples in the table. Each combination, {employeeID}, {employeeID, name}, {employeeID, name, job}, and so on is a superkey. {employeeID} is a candidate key, since no subset of its attributes is also a superkey. {employeeID, name, job, departmentID} is the trivial superkey.If attribute set K is a superkey of relation R, then at all times it is the case that the projection of R over K has the same cardinality as R itself.- the content below is remote from Wikipedia
- it has been imported raw for GetWiki
⢠{}
⢠{Monarch Name}
⢠{Monarch Number}
⢠{Royal House}
⢠{Monarch Name, Monarch Number}
⢠{Monarch Name, Royal House}
⢠{Monarch Number, Royal House}
⢠{Monarch Name, Monarch Number, Royal House}
Second, eliminate all the sets which do not meet superkey's requirement. For example, {Monarch Name, Royal House} cannot be a superkey because for the same attribute values (Edward, Plantagenet), there are two distinct tuples: - (Edward, II, Plantagenet)
- (Edward, III, Plantagenet)
- {Monarch Name, Monarch Number} â this is also the candidate key
- {Monarch Name, Monarch Number, Royal House}
See also
References
{{reflist}}Further reading
- BOOK, Silberschatz, Abraham, Database System Concepts (6th ed.), 2011, McGraw-Hill, 978-0-07-352332-3, 45â46,
External links
- Relation Database terms of reference, Keys: An overview of the different types of keys in an RDBMS
- content above as imported from Wikipedia
- "superkey" does not exist on GetWiki (yet)
- time: 5:08am EDT - Sat, May 18 2024
- "superkey" does not exist on GetWiki (yet)
- time: 5:08am EDT - Sat, May 18 2024
[ this remote article is provided by Wikipedia ]
LATEST EDITS [ see all ]
GETWIKI 23 MAY 2022
The Illusion of Choice
Culture
Culture
GETWIKI 09 JUL 2019
Eastern Philosophy
History of Philosophy
History of Philosophy
GETWIKI 09 MAY 2016
GetMeta:About
GetWiki
GetWiki
GETWIKI 18 OCT 2015
M.R.M. Parrott
Biographies
Biographies
GETWIKI 20 AUG 2014
GetMeta:News
GetWiki
GetWiki
© 2024 M.R.M. PARROTT | ALL RIGHTS RESERVED