Rdmil
September 2010
edit
Welcome to Wikipedia. We welcome and appreciate your contributions, including your edits to SQL, but we cannot accept original research. Original research also encompasses novel, unpublished syntheses of previously published material. Please be prepared to cite a reliable source for all of your information. Thank you. SarekOfVulcan (talk) 17:28, 22 September 2010 (UTC)
Ok... but I can not afford to buy a copy of C.J. Date's book right now, to cite the relevant texts. But his attempted object modeling of relational database entities is pretty easy to find, if anyone has a copy. Rdmil (talk) 18:57, 24 September 2010 (UTC)
So, in response, you deleted my entire entry, and not just the bit about c.j.date's book. Never mind that most of what you deleted was about as original as 1234+5678=6912.... I am not sure what you are looking for here -- do I need to dredge up cites for every sentence I posted? [I can, given time, but that seems excessive.] Rdmil (talk) 19:14, 24 September 2010 (UTC)
Note: this is very low priority for me, and we are talking stuff that was originally published 10..30 years ago. That none of this has made it into wikipedia means that it is not a high priority for anyone that knows anything about this subject. Nevertheless, a few quick web searches are finding me some probably inadequate references. I will try visiting here every few weeks until I feel I have accumulated sufficient references to back the ideas I tried to present in http://en.wikipedia.org/w/index.php?title=SQL&oldid=386348034, and will use this talk page as a scratchpad. If no one steps up and modifies the original page for correctness then I may eventually try again, when I have references for every sentence I posted.
http://support.microsoft.com/kb/139444 "Duplicate PKs are a violation of entity integrity, and should be disallowed in a relational system."
http://blogcritics.org/scitech/article/video-training-review-sql-and-relational/ ""No Duplicates, No Nulls" are two of the most obvious SQL departures from the relational model. That is, based off of Codd's model, duplicate records were not allowed. Duplicate entries are a product of database committees and DBMS developers."
(But, to do this right, I should buy a copy of every book C.J.Date has written, so I can provide really good, authoritative quotes.)