Talk:Composite key

This is the talk page for discussing improvements to the Composite key article.
This is not a forum for general discussion of the article's subject.

Put new text under old text. Click here to start a new topic.
New to Wikipedia? Welcome! Learn to edit; get help.

Article policies

Find sources: Google (books · news · scholar · free images · WP refs) · FENS · JSTOR · TWL

Databases (inactive)

This article is within the scope of WikiProject Databases, a project which is currently considered to be inactive.DatabasesWikipedia:WikiProject DatabasesTemplate:WikiProject DatabasesDatabases articles

Computing: Software / CompSci Low‑importance

This article is within the scope of WikiProject Computing, a collaborative effort to improve the coverage of computers, computing, and information technology on Wikipedia. If you would like to participate, please visit the project page, where you can join the discussion and see a list of open tasks.ComputingWikipedia:WikiProject ComputingTemplate:WikiProject ComputingComputing articles

Low

This article has been rated as Low-importance on the project's importance scale.

This article is supported by WikiProject Software (assessed as Low-importance).

This article is supported by WikiProject Computer science (assessed as Mid-importance).

Things you can help WikiProject Computer science with:

Here are some tasks awaiting attention:

Article requests :
- Requested articles/Applied arts and sciences/Computer science, computing, and Internet
Cleanup :
- Computer science articles needing attention
- Computer science articles needing expert attention
Copyedit :
- Computing
Expand :
- Computer science
Infobox :
- Computer science articles without infoboxes
Maintain :
- Timeline of computing 2020–present
Photo :
- Find pictures for the biographies of computer scientists (see List of computer scientists)
- Computing articles needing images
Stubs :
- Computer science stubs
Unreferenced :
- WikiProject Computer science/Unreferenced BLPs
Project-related :
- Tag all relevant articles in Category:Computer science and sub-categories with {{WikiProject Computer science}}

Untitled

I think this page is very unhelpful unless you know full database terminology, in which case you wouldn't need to look it up. Can someone put up an example that would give a normal person an idea of what this is? --67.125.22.141 (talk) 08:53, 9 December 2007 (UTC)[reply]

Yeah, I would agree. An example is definitely needed here; especially since the page for Primary/Unique Key has examples for its definition, yet this page is pretty useless if you need to see a specific example of a compound key in relation to a table or tables. —Preceding unsigned comment added by 199.172.169.15 (talk) 22:54, 23 January 2008 (UTC)[reply]

WTF is a simple key?

WTF is a simple key? —Preceding unsigned comment added by 99.224.115.100 (talk) 22:13, 7 February 2010 (UTC)[reply]

EDIT*: Eh... they explain what it is, but I've never heard that used anywhere.. —Preceding unsigned comment added by 99.224.115.100 (talk) 22:18, 7 February 2010 (UTC)[reply]

A number of achademic references use simple key or simple attribute to represent a single component with an independent execution. One being the well regarded Connnnolly.T, Begg.C. (2010) 'Database Systems: A practical Approach to Design, implementation, and Management' Fifth Edition. Adison-Wesley p.329. Hope this helps. —Preceding unsigned comment added by ProcerusDecor (talk • contribs) 17:01, 17 April 2010 (UTC)[reply]

Recommend merge with Unique key

The following discussion is closed. Please do not modify it. Subsequent comments should be made in a new section. A summary of the conclusions reached follows.

Merger not done. There was no consensus to merge. WTF? (talk) 23:01, 10 February 2013 (UTC)[reply]

This is, at best, a paragraph or two worth of information that should be presented in a subsection of the Unique key article. Recommend merging this article into that one. 69.116.234.82 (talk) 02:58, 27 March 2010 (UTC)[reply]

I would suggest the creation of a Key(database) artical which contains both of the suggested files.--140.192.124.43 (talk) 00:18, 2 April 2010 (UTC)[reply]

I have added a link to a site that lists all the keys in summary. Would it not be better to have all RDBMS key references as a single page not just add this to the Unigue key. and have each of the terms asa sub reference as suggested? I hope the added link is useful. Also on the site is a terms of reference section. Again is it worth lifting this and other pages in Wikipedia to a single terms of reference page? ProcerusDecor (talk) 15:46, 17 April 2010 (UTC)[reply]

I'd suggest that unique key page not be amended with this information. Instead the aforementioned key database page should be used to combine all key field information pages together for the user to better find the information. —Preceding unsigned comment added by 129.21.237.188 (talk) 18:54, 17 May 2010 (UTC)[reply]

I agree that this should not be added to unique key, but combined with an RDBS Terminology page or a page on keys. Uniqueness is not a relevant distinction between compound and composite keys. Also: students with only just enough database knowledge to be dangerous frequently confuse these terms (compound and composite) or use them interchangeably, so the couple of paragraphs certainly have some merit. —Preceding unsigned comment added by 158.83.71.238 (talk) 20:50, 18 January 2011 (UTC)[reply]

The discussion above is closed. Please do not modify it. Subsequent comments should be made on the appropriate discussion page. No further edits should be made to this discussion.

Compound key

1. It seems wrong that a compound key is made up of simple keys, as a compound key is itself a minimal superkey, e.g. any of its proper subsets must not be a simple key. From what the example below suggests, it's more plausible to say that a compound key is made up of two or more foreign keys (that are not simple keys, but it's almost always the case I guess ?).

2. It's also odd to write "simple (foreign) keys": they are not synonyms.

According to the two points above, I permit myself to change "simple (foreign) keys" to "foreign keys". As I'm by no means a DB expert, feel free to rollback or make it clearer. Unfortunately, I don't have references to support my thoughts, but something definitely goes wrong in the first point. FirminMartin (talk) 18:03, 24 August 2021 (UTC)[reply]