At 10:20 AM 12/7/2001 -0600, you wrote: >Now I read that rule that there are 3 things needed to uniquely define a >value or cell to the RDBMS. That is the table name, column name and the >key. So my interpretation of this is that there is nothing in the Codd >rules that says I can't have duplicate column names in differnt tables >because the RDBMS should be defining cell locations by >TableName.ColumnName.Key. And if my TableName name is different, then the >RDBMS should be able to figure out what column I want; the one in >TableName. > >So IMHO if the RDBMS is following Rule #2, it should allow us to name our >columns anything we want. > >JeffS
Dear JeffS; I agree 100% with the statement that you should be able to have duplicate column names in different tables. I don't think that this was ever the argument. R:BASE has always allowed for duplicate column names that span different tables. The issue at hand here is whether or not the duplicate columns must have the same data type. To the best of my knowledge, Dr. Codd had never addressed this issue directly in his original model. This is more of a scholarly interpretation of what makes the most relational sense. Unfortunately, this topic is almost as rhetorical as religion, or the chicken and the egg theory. Since no prominent person throughout history has ever made a statement about it, we can only form our own opinions, and defend them to the death. All I can offer, is my own reasoning, and have it backed up by the fact that someone else obviously shared this view, otherwise R:BASE would very likely be functioning differently than it is. The bottom line...Not everything is always right or wrong. Sometimes it is different, and that makes it neither right or wrong. Mike ------------------------------------------- Michael Willochell Director, Customer Support R:BASE Technologies, Inc. 3935 Old William Penn Highway Murrysville, PA 15668-1854 Phone: 724-733-0053 FAX: 724-733-0196 URL: www.rbase.com Sales: [EMAIL PROTECTED] Support: [EMAIL PROTECTED] ------------------------------------------- ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l
