Third normal form: Revision history

7 March 2025

• curprev 16:4116:41, 7 March 2025 Mejiwa talk contribs 14,673 bytes +74 Corrected Codd's definition of transitive dependence: Attribute sets must be disjoint! (Codd said "distinct" but he must have meant "disjoint", because distinct allows trivial dependencies) undo
• curprev 16:1916:19, 7 March 2025 Mejiwa talk contribs 14,599 bytes +14 Corrected primary key -> candidate keys (a primary key might not have been chosen), and used original wording of the paper undo

12 January 2025

• curprev 15:0615:06, 12 January 2025 Ronoth talk contribs 14,585 bytes −52 →"Nothing but the key": First normal form does not require a key. First normal form eliminates the possibility of relations as attributes. undo Tags: Mobile edit Mobile app edit Android app edit App section source

22 December 2024

• curprev 00:1800:18, 22 December 2024 Conovaloff talk contribs 14,637 bytes +88 →See also: Added 4NF, 5NF, 6NF undo Tags: Mobile edit Mobile web edit

21 December 2024

• curprev 23:5823:58, 21 December 2024 Conovaloff talk contribs 14,549 bytes +59 →See also: Added 1NF, 2NF undo Tags: Mobile edit Mobile web edit

3 October 2024

• curprev 22:0222:02, 3 October 2024 82.31.252.171 talk 14,490 bytes −1 Removed an extraneous space character. undo Tags: Mobile edit Mobile web edit

18 August 2024

• curprev 11:5211:52, 18 August 2024 Dexxor talk contribs m 14,491 bytes +5 +wikilink to canonical cover undo

26 May 2024

• curprev 16:1116:11, 26 May 2024 BD2412 talk contribs 14,486 bytes +14 dab fix undo

13 May 2024

• curprev 06:0106:01, 13 May 2024 OAbot talk contribs m 14,472 bytes +17 Open access bot: doi updated in citation with #oabot. undo

6 May 2024

• curprev 18:2118:21, 6 May 2024 Wqwt talk contribs 14,455 bytes +356 →Considerations for use in reporting environments: add ref to tidy data undo Tag: Visual edit

14 March 2024

• curprev 20:4120:41, 14 March 2024 Sauer202 talk contribs 14,099 bytes +30 →"Nothing but the key" undo
• curprev 20:0820:08, 14 March 2024 Sauer202 talk contribs 14,069 bytes +2 To keep the focus flow of the sentences, this sentence may be better suited in parenthesis. undo
• curprev 20:0120:01, 14 March 2024 Sauer202 talk contribs 14,067 bytes −16 No edit summary undo
• curprev 20:0120:01, 14 March 2024 Sauer202 talk contribs 14,083 bytes +20 No edit summary undo
• curprev 19:5719:57, 14 March 2024 Sauer202 talk contribs 14,063 bytes +19 No edit summary undo
• curprev 19:2019:20, 14 March 2024 Sauer202 talk contribs 14,044 bytes +16 →Considerations for use in reporting environments undo

4 March 2024

• curprev 17:1317:13, 4 March 2024 134.214.188.164 talk 14,028 bytes +113 No edit summary undo Tag: Disambiguation links added

24 December 2023

• curprev 12:2812:28, 24 December 2023 Citation bot talk contribs 13,915 bytes +23 Alter: template type. Add: date, newspaper. Removed parameters. Some additions/deletions were parameter name changes. | Use this bot. Report bugs. | Suggested by Abductive | Category:Database normalization | #UCB_Category 19/20 undo

5 December 2023

• curprev 17:4017:40, 5 December 2023 208.85.193.25 talk 13,892 bytes −1 →Equivalence of the Codd and Zaniolo definitions of 3NF: fixed iff to if undo Tag: Visual edit

15 September 2023

• curprev 21:2421:24, 15 September 2023 2601:14d:4f00:6820:b10b:b479:2671:436e talk 13,893 bytes +196 Finish the proof of the equivalence between the Codd and Zaniolo definitions of 3NF undo
• curprev 21:1321:13, 15 September 2023 2601:14d:4f00:6820:b10b:b479:2671:436e talk 13,697 bytes +1 fixing grammar typo undo

12 September 2023

• curprev 23:2623:26, 12 September 2023 2601:14d:4f00:171c:2d6c:17f6:c555:5b84 talk 13,696 bytes +22 Fix rephrasing of Zaniolo's definition undo

25 March 2023

• curprev 04:4504:45, 25 March 2023 Jarfuls of Tweed talk contribs 13,674 bytes +181 →Definition of third normal form: gave simplified wording and replaced A with Y because it is an easier notation to read undo Tag: Visual edit

21 March 2023

• curprev 01:0001:00, 21 March 2023 Achmad Rachmani talk contribs 13,493 bytes +43 →Computation: Missing archive date undo

15 March 2023

• curprev 01:3201:32, 15 March 2023 Jarfuls of Tweed talk contribs 13,450 bytes +531 →Computation: Explained 3NF decomposition undo Tag: Visual edit

10 March 2023

• curprev 14:3014:30, 10 March 2023 94.255.131.211 talk 12,919 bytes −6 →Definition of third normal form undo

3 April 2022

• curprev 01:2901:29, 3 April 2022 Vycl1994 talk contribs 12,925 bytes +8 →Definition of third normal form undo

30 March 2022

• curprev 23:4023:40, 30 March 2022 2601:1c0:8780:310:ac21:ca35:a5a3:9a5a talk 12,917 bytes −4 →"Nothing but the key" undo

23 February 2022

• curprev 05:1805:18, 23 February 2022 115.248.146.117 talk 12,921 bytes −13 →Definition of third normal form undo Tag: Manual revert
• curprev 05:1705:17, 23 February 2022 115.248.146.117 talk 12,934 bytes +13 →Definition of third normal form undo Tag: Reverted

12 February 2022

• curprev 04:4504:45, 12 February 2022 Pppery talk contribs 12,921 bytes +1 No edit summary undo

28 November 2021

• curprev 23:5923:59, 28 November 2021 73.61.9.192 talk 12,920 bytes −2 →"Nothing but the key" undo

16 November 2021

• curprev 13:0013:00, 16 November 2021 Tea2min talk contribs 12,922 bytes −1 →top: Try to fix confusing piped link. undo

29 September 2021

• curprev 17:3917:39, 29 September 2021 Jarble talk contribs m 12,923 bytes +4 linking undo

16 April 2021

• curprev 09:0209:02, 16 April 2021 511KeV talk contribs 12,919 bytes +119 Importing Wikidata short description: "Normalizing a database design to reduce the duplication of data and ensure referential integrity" (Shortdesc helper) undo

4 March 2021

• curprev 18:4318:43, 4 March 2021 79.71.0.240 talk 12,800 bytes −7 No edit summary undo Tag: Manual revert
• curprev 18:4218:42, 4 March 2021 79.71.0.240 talk 12,807 bytes +7 No edit summary undo Tag: Reverted

31 January 2021

• curprev 15:0615:06, 31 January 2021 Monkbot talk contribs m 12,800 bytes +2 Task 18 (cosmetic): eval 2 templates: hyphenate params (2×); undo Tag: AWB

19 January 2021

• curprev 17:1517:15, 19 January 2021 140.177.239.221 talk 12,798 bytes −1 →"Nothing but the key": No major style guide (CMS, MLA, Oxford) permits this use of a colon. All guides indicate that a colon used in a sentence must be preceded by a main clause. undo Tag: Visual edit

14 November 2020

• curprev 08:5408:54, 14 November 2020 81.97.174.93 talk 12,799 bytes −23 Undid revision 988608379 by 5.63.74.54 (talk) undo Tag: Undo
• curprev 05:2405:24, 14 November 2020 5.63.74.54 talk 12,822 bytes +23 No edit summary undo Tag: Reverted

10 October 2020

• curprev 03:5103:51, 10 October 2020 115.99.13.45 talk 12,799 bytes −8 →External links undo

4 October 2020

• curprev 11:5211:52, 4 October 2020 Jason Quinn talk contribs 12,807 bytes +8 cite template organize undo

31 August 2020

• curprev 19:1419:14, 31 August 2020 89.211.97.226 talk 12,799 bytes +2 inserted a parentheses undo

5 May 2020

• curprev 08:1908:19, 5 May 2020 DannyS712 talk contribs m 12,797 bytes 0 Fixing the location of periods / full stops undo

3 April 2020

• curprev 20:1620:16, 3 April 2020 2601:281:8101:770:d865:840c:8913:ba91 talk 12,797 bytes −1 No edit summary undo

25 February 2020

• curprev 17:3817:38, 25 February 2020 Sillyfolkboy talk contribs 12,798 bytes +814 rewrite lead to improve readability for less technical audiences undo

4 November 2019

• curprev 19:4919:49, 4 November 2019 128.151.150.18 talk 11,984 bytes 0 No edit summary undo Tags: Mobile edit Mobile web edit
• curprev 19:4819:48, 4 November 2019 128.151.150.18 talk 11,984 bytes +4 Added a link/tag undo Tags: Mobile edit Mobile web edit

20 October 2019

• curprev 16:1316:13, 20 October 2019 Oradium talk contribs m 11,980 bytes +2 →"Nothing but the key": primary key->candidate key undo