No, I personally disbelive that premise for a number of reasons, sure some people think it's correct (or at least will say it to give a basic overview of something), but it is not universally agreed. to remain NPOV, the bullet point should be removed or be prefaced with a modifier like "some say that". For Example, Hugh Darwen discusses it at length in his " The Askew Wall" discussion and paper.
For example, I can give an example of a few relations that violate first normal form:
a : relation { id : integer { key }, name : string, nameofpet1 : string, nameofpet2 : string, nameofpet3 : string }
this is the one that I'm talking about that contradicts #2. with repeating groups, you have a violation of (what some would call) the first normal form. Sure, not all will call this a violation of first normal form, but if the bullet point you want included is included, then the second bullet point should be removed.
b : relation { id : integer { key }, name : structure { firstname : string, lastname : string } } b2 : relation { id : integer { key }, name : string, sound : audioStream }
I think it's pretty clear that these definitely violates first normal form, as they have a non-atomic type, but it is still a valid relation. Also, sure, some people don't think this is a violation of 1NF. Also many "Relational" DBMSs won't support such a beast, so some exclude such kinds of constructs as being relations in the first place.
c : relation { id : integer { key }, name : string, pets : relation { petid : integer { key }, petname : string, petspecies : integer { references species } } }
this one has a complex relation as the type of one of the columns. Most don't think that relations can belong in relations, that it ceases to become a relation once this occurs. I don't understand their reasoning, but they claim it. There is an entire group of people who like making databases that can do this, they are usually called "non-first-normal-form relational databases"
In all of these cases, some people will say that these things can't be relations, or that these things can be in relations, and we can make a small exception for not calling them violations of 1NF so that we can do other normalizations on them (because 2NF requires 1NF).
So, no, I don't think we can re-add that bullet unqualified. McKay 16:46, 11 April 2007 (UTC)
a : relation { id : integer { key }, name : string, nameofpet1 : string { nullable }, nameofpet2 : string { nullable }, nameofpet3 : string { nullable }, nameofpet4 : string { nullable }, nameofpet5 : string { nullable }, nameofpet6 : string { nullable }, nameofpet7 : string { nullable }, nameofpet8 : string { nullable }, nameofpet9 : string { nullable }, nameofpet10 : string { nullable }, nameofpet11 : string { nullable }, nameofpet12 : string { nullable } }
Hi,
You appear to be eligible to vote in the current
Arbitration Committee election. The
Arbitration Committee is the panel of editors responsible for conducting the Wikipedia
arbitration process. It has the authority to enact binding solutions for disputes between editors, primarily related to serious behavioural issues that the community has been unable to resolve. This includes the ability to impose
site bans,
topic bans, editing restrictions, and other measures needed to maintain our editing environment. The
arbitration policy describes the Committee's roles and responsibilities in greater detail. If you wish to participate, you are welcome to
review the candidates' statements and submit your choices on
the voting page. For the Election committee,
MediaWiki message delivery (
talk)
13:06, 23 November 2015 (UTC)
Hi,
You appear to be eligible to vote in the current
Arbitration Committee election. The
Arbitration Committee is the panel of editors responsible for conducting the Wikipedia
arbitration process. It has the authority to enact binding solutions for disputes between editors, primarily related to serious behavioural issues that the community has been unable to resolve. This includes the ability to impose
site bans,
topic bans, editing restrictions, and other measures needed to maintain our editing environment. The
arbitration policy describes the Committee's roles and responsibilities in greater detail. If you wish to participate, you are welcome to
review the candidates' statements and submit your choices on
the voting page. For the Election committee,
MediaWiki message delivery (
talk)
13:32, 23 November 2015 (UTC)
No, I personally disbelive that premise for a number of reasons, sure some people think it's correct (or at least will say it to give a basic overview of something), but it is not universally agreed. to remain NPOV, the bullet point should be removed or be prefaced with a modifier like "some say that". For Example, Hugh Darwen discusses it at length in his " The Askew Wall" discussion and paper.
For example, I can give an example of a few relations that violate first normal form:
a : relation { id : integer { key }, name : string, nameofpet1 : string, nameofpet2 : string, nameofpet3 : string }
this is the one that I'm talking about that contradicts #2. with repeating groups, you have a violation of (what some would call) the first normal form. Sure, not all will call this a violation of first normal form, but if the bullet point you want included is included, then the second bullet point should be removed.
b : relation { id : integer { key }, name : structure { firstname : string, lastname : string } } b2 : relation { id : integer { key }, name : string, sound : audioStream }
I think it's pretty clear that these definitely violates first normal form, as they have a non-atomic type, but it is still a valid relation. Also, sure, some people don't think this is a violation of 1NF. Also many "Relational" DBMSs won't support such a beast, so some exclude such kinds of constructs as being relations in the first place.
c : relation { id : integer { key }, name : string, pets : relation { petid : integer { key }, petname : string, petspecies : integer { references species } } }
this one has a complex relation as the type of one of the columns. Most don't think that relations can belong in relations, that it ceases to become a relation once this occurs. I don't understand their reasoning, but they claim it. There is an entire group of people who like making databases that can do this, they are usually called "non-first-normal-form relational databases"
In all of these cases, some people will say that these things can't be relations, or that these things can be in relations, and we can make a small exception for not calling them violations of 1NF so that we can do other normalizations on them (because 2NF requires 1NF).
So, no, I don't think we can re-add that bullet unqualified. McKay 16:46, 11 April 2007 (UTC)
a : relation { id : integer { key }, name : string, nameofpet1 : string { nullable }, nameofpet2 : string { nullable }, nameofpet3 : string { nullable }, nameofpet4 : string { nullable }, nameofpet5 : string { nullable }, nameofpet6 : string { nullable }, nameofpet7 : string { nullable }, nameofpet8 : string { nullable }, nameofpet9 : string { nullable }, nameofpet10 : string { nullable }, nameofpet11 : string { nullable }, nameofpet12 : string { nullable } }
Hi,
You appear to be eligible to vote in the current
Arbitration Committee election. The
Arbitration Committee is the panel of editors responsible for conducting the Wikipedia
arbitration process. It has the authority to enact binding solutions for disputes between editors, primarily related to serious behavioural issues that the community has been unable to resolve. This includes the ability to impose
site bans,
topic bans, editing restrictions, and other measures needed to maintain our editing environment. The
arbitration policy describes the Committee's roles and responsibilities in greater detail. If you wish to participate, you are welcome to
review the candidates' statements and submit your choices on
the voting page. For the Election committee,
MediaWiki message delivery (
talk)
13:06, 23 November 2015 (UTC)
Hi,
You appear to be eligible to vote in the current
Arbitration Committee election. The
Arbitration Committee is the panel of editors responsible for conducting the Wikipedia
arbitration process. It has the authority to enact binding solutions for disputes between editors, primarily related to serious behavioural issues that the community has been unable to resolve. This includes the ability to impose
site bans,
topic bans, editing restrictions, and other measures needed to maintain our editing environment. The
arbitration policy describes the Committee's roles and responsibilities in greater detail. If you wish to participate, you are welcome to
review the candidates' statements and submit your choices on
the voting page. For the Election committee,
MediaWiki message delivery (
talk)
13:32, 23 November 2015 (UTC)