This article is ratedStub-class on Wikipedia'scontent assessment scale. It is of interest to the followingWikiProjects:

Computing This article is within the scope ofWikiProject Computing, a collaborative effort to improve the coverage ofcomputers,computing, andinformation technology on Wikipedia. If you would like to participate, please visit the project page, where you can jointhe discussion and see a list of open tasks.ComputingWikipedia:WikiProject ComputingTemplate:WikiProject ComputingComputing ??? This article has not yet received a rating on theproject's importance scale. This article has beenautomatically rated by abot or other tool asStub-class because it uses astub template. Please ensure the assessment is correct before removing the|auto= parameter.

Can't a doctor have multiple patients and a patient multiple doctors? Wouldn't the example mentioned then be of a many-to-many and not many-to-one type?

Well it seems to be correct there: there is a many-to-many example regarding doctors and patients and one-to-many between doctors and departments.Zeratul021 (talk)21:12, 15 January 2009 (UTC)[reply]

In this article the relational model is mixed up with ER-Modeling! There is no n:m relationship between relational tables.In ER modeling the cardinality of a relationship type is a constraint that limits the number of potentially related entities.

In the relationsal data model the cardinality of a table is the number of tuples (rows) in that table.—Precedingunsigned comment added by84.147.211.226 (talk)21:02, 7 May 2010 (UTC)[reply]

This article is crap. Firstly, the previous commenter is correct, the cardinality of a table is the number of distinguishable rows in that table. However, a far more common use of the term in datamodelling is in respect of a column or combination of columns. In this context the term refers to the degree to which a column value differentiates its row from other rows: a column with "high cardinality" is a good candidate for indexing. Secondly, Date didnot invent a method, he devised a model. There are endless ways that model can be applied, and while Date certainly wrote a seminal text on the application of his model, it is absurd to conflate the model with possible ways to apply it, not to mention irrelevant to the meaning of cardinality in datamodelling. Thirdly, normalisation serves to prevent update anomalies and eliminate redundant storage. It does not improve performance in and of itself, although it will often afford opportunities for better indexing.— Precedingunsigned comment added byPeterWone (talk •contribs)05:59, 21 December 2011 (UTC)[reply]

I fully agree with the previous three commentators. Not only is the article utter crap but it's very badly written too: just look at the second sentence! The first commentator suspects a confusion with E-R modelling. That may be the case but on the university courses I was involved with in the UK over many years (namely, those offered by The Open University), the property in question, of a relationship between two entity types, was called the degree, not the cardinality. I strongly recommend this article for summary deletion.

AndrewWarden (talk)15:32, 21 July 2015 (UTC)[reply]

I'm no terminology expert, but it seems that although cardinality is a mess of overlapping definitions, "degree" is certainly something else. Specifically, degree is about the number of entities present, and cardinality (as I've most commonly seen it defined and used wandering on the internet) is about the relationship between those entities.— Precedingunsigned comment added by99.225.163.254 (talk)13:11, 8 December 2021 (UTC)[reply]

Please help upgrading its connectivity.93.172.178.33 (talk)12:24, 17 November 2014 (UTC)[reply]

The german version is much better.https://de.wikipedia.org/wiki/Kardinalit%C3%A4t_(Datenbankmodellierung)

If there is no other related article I'd like to enhance it with translations from the german versionDirk Hoeschen (talk)10:22, 3 December 2015 (UTC)[reply]

"Common cardinalities include one-to-one, one-to-many, and many-to-many."Isn't there only those three? I guess you could say there is a cardinality from any set of integer to any set of integer (ie 2 or 4 to exactly 7) but every specific case of that would still be one to one, one to many, or many to many, but with specific restrictions. So I think this should be changed to "The three categories of cardinality are one-to-one, one-to-many, and many-to-many."Does this make sense?99.225.163.254 (talk)12:54, 8 December 2021 (UTC)[reply]

Hi everyone - I noticed this article had zero references. I went through and added a few. A lot of easily accessible sources appear to be blogs online. If anyone knows of a good textbook to source, I think this article could benefit from it. I also reworked the lead to include a clearer definition and am going to remove the lead template. If you think it still needs work, feel free to add it back or update the lead accordingly. I think it's better than it was before, but this article still needs a lot of work.Wskent (talk)18:46, 7 September 2022 (UTC)[reply]

• Stub-Class Computing articles
• Unknown-importance Computing articles
• Automatically assessed Computing articles
• All Computing articles

• Talk pages with comments before the first section