Content deleted Content added
Gnomingstuff (talk | contribs) rv test |
|||
| (6 intermediate revisions by 4 users not shown) | |||
Line 513:
== The section "Cristopher J. Date's definition of 1NF" ==
This section seem to contain the definition of "relation" rather than the definition of 1NF. Data being in relational form is a prerequisite for 1NF, but it is not the ''definition ''of 1NF since we can have relations which are ''not ''in 1NF - after all, normalization is defined as bringing non-1NF relations into 1NF. So I suggest either removing this section altogether or moving it to another article, perhaps
:It's not clear from the section, but Date's view is that being in 1NF and being a relation are equivalent, and so "relations" not in 1NF are not relations at all. [[User:Charnel Mouse|Charnel Mouse]] ([[User talk:Charnel Mouse|talk]]) 23:49, 17 May 2025 (UTC)
::Relations as a mathematical structure predate its use in database terminology, so this sounds like a misunderstanding. [[Special:Contributions/80.62.117.169|80.62.117.169]] ([[User talk:80.62.117.169|talk]]) 06:27, 27 May 2025 (UTC)
:It's true that this section should instead contain the Date's definition of 1NF rather than his corollary of 1NF being equivalent to his definition of a relation. And I believe Date's definition is very valuable and should be paid more attention to. He formalized this concept very rigorously. [[User:Shuween|Shuween]] ([[User talk:Shuween|talk]]) 08:38, 25 June 2025 (UTC)
== Drawbacks ==
The section on drawbacks is problematic and lacks sources. The performance concern seem to apply to the relational model as a whole rather than specifically 1NF and would better fit in the articles for [[Relational database]] or [[NoSQL]]. The paragraph about object/relational impedance mismatch also seem misplaced here since again it is not specifically about 1NF. There is already an article about [[Object–relational impedance mismatch]]. Given the lack of sources I suggest we just remove this section though. The controversy about whether complex types are allowed in 1NF already have its own section. [[Special:Contributions/80.62.117.169|80.62.117.169]] ([[User talk:80.62.117.169|talk]]) 14:23, 11 May 2025 (UTC)
| |||