Second normal form: Revision history

Filter revisionsshowhide

To date:

Tag filter:

Invert selection

External tools:

For any version listed below, click on its date to view it. For more help, see Help:Page history and Help:Edit summary. (cur) = difference from current version, (prev) = difference from preceding version, m = minor edit, → = section edit, ← = automatic edit summary

curprev 14:3314:33, 30 October 2024 Darcourse talk contribs m 6,514 bytes +1 No edit summary undo

curprev 16:1216:12, 30 July 2024 Likes2wiki talk contribs 6,134 bytes −527 Remove this section, which appears to just re-state part of the definition in the intro. Also, the use of “predictable” here might be misleading; it is possible to infer the statistical distribution of values of an attribute given its candidate key, hence predicting the value even without fully determining it. undo Tags: Visual edit Mobile edit Mobile web edit

curprev 01:1001:10, 10 July 2024 Oradium talk contribs 6,661 bytes −145 removed the informal description because it is wrong and contradicted by the formal definition that follows - non-prime means not part of *any* candidate key. undo

curprev 01:5901:59, 12 June 2024 Wqwt talk contribs 6,806 bytes +41 No edit summary undo Tag: Visual edit

curprev 20:2520:25, 30 April 2024 Pooryorick~enwiki talk contribs 6,765 bytes +142 Add an intuitive description of the form undo

curprev 05:1905:19, 1 January 2024 OAbot talk contribs m 6,638 bytes +17 Open access bot: doi updated in citation with #oabot. undo

curprev 12:2812:28, 24 December 2023 Citation bot talk contribs 6,621 bytes +36 Add: doi, issue. | Use this bot. Report bugs. | Suggested by Abductive | Category:Database normalization | #UCB_Category 20/20 undo

curprev 09:1509:15, 17 November 2023 Awheeley talk contribs m 6,585 bytes +576 I added simpler explanations, particularly after the words 'Put simply, ...' undo

curprev 06:3606:36, 28 September 2023 InternetArchiveBot talk contribs 6,009 bytes +154 Rescuing 1 sources and tagging 0 as dead.) #IABot (v2.0.9.5) (AManWithNoPlan - 15323 undo

curprev 20:2220:22, 17 June 2023 Achilles999 talk contribs m 5,855 bytes −1 Removed extra parenthesis. undo Tag: 2017 wikitext editor

curprev 22:2622:26, 2 April 2023 Patar knight talk contribs 5,856 bytes +53 Adding local short description: "Term in database normalization", overriding Wikidata description "database normalization requirement after first normal form" undo Tag: Shortdesc helper

curprev 19:3719:37, 18 March 2023 Itsgothyme talk contribs m 5,803 bytes −3 Grammar fix undo

curprev 03:3703:37, 14 March 2023 Jarfuls of Tweed talk contribs 5,806 bytes −65 →Example: clarified wording undo Tag: Visual edit
curprev 03:1303:13, 14 March 2023 Jarfuls of Tweed talk contribs 5,871 bytes +206 →Example: Added further explanation for the given example undo Tag: Visual edit
curprev 03:0603:06, 14 March 2023 Jarfuls of Tweed talk contribs 5,665 bytes +304 →Example: Fixed typos, removed redundancy, gave further explanation of how to decompose the table in the example undo Tag: Visual edit
curprev 02:5302:53, 14 March 2023 Jarfuls of Tweed talk contribs 5,361 bytes +88 →2NF and candidate keys: reorganized article and made some grammar fixes undo Tag: Visual edit

curprev 21:3821:38, 9 March 2023 Jarfuls of Tweed talk contribs 5,273 bytes +377 →2NF and candidate keys: added explanation of how to convert 1nf to 2nf undo Tag: Visual edit

curprev 18:4418:44, 18 October 2022 208.184.212.50 talk 4,896 bytes +1 spelling Mode -> Model undo

curprev 06:4206:42, 12 October 2022 97.115.44.186 talk 4,895 bytes +246 Added clarification for why Manufacturer country is not part of a candidate key. undo

curprev 03:5003:50, 23 March 2022 103.15.254.76 talk 4,649 bytes −16 No edit summary undo
curprev 03:4903:49, 23 March 2022 103.15.254.76 talk 4,665 bytes +21 No edit summary undo Tag: extraneous markup

curprev 21:0321:03, 25 October 2021 Pppery talk contribs 4,644 bytes −86 →See also: Do you really think people won't be able to figure out there's a navbox on their own? undo

curprev 12:3712:37, 28 July 2021 Ahmad wikipedia11 talk contribs m 4,730 bytes −407 Removing redundent confusing column. undo

curprev 14:3814:38, 13 July 2021 103.195.202.33 talk 5,137 bytes +2 →2NF and candidate keys undo Tag: Manual revert
curprev 14:3714:37, 13 July 2021 103.195.202.33 talk 5,135 bytes −2 →2NF and candidate keys undo Tag: Reverted
curprev 14:3614:36, 13 July 2021 103.195.202.33 talk 5,137 bytes +2 →2NF and candidate keys undo Tag: Visual edit

curprev 18:0318:03, 27 October 2020 J Hooper talk contribs 5,135 bytes +5 →2NF and candidate keys: Recaps the list, shouldn't be in it; phrasing undo
curprev 17:5617:56, 27 October 2020 J Hooper talk contribs 5,130 bytes +7 →2NF and candidate keys: Must be a proper subset undo

curprev 23:3023:30, 3 October 2020 Jason Quinn talk contribs 5,123 bytes +67 cleanup and further use of cite templates undo

curprev 21:3821:38, 4 May 2020 Trappist the monk talk contribs m 5,056 bytes −2 →Further reading: remove 'invisible' characters from cs1|2 template parameters; (1× NBSP; 1× extra space) undo Tag: AWB

curprev 00:3000:30, 24 February 2020 2601:198:80:92a0:adc1:4c29:fadb:1dfa talk 5,058 bytes −1 →2NF and candidate keys undo
curprev 00:2800:28, 24 February 2020 2601:198:80:92a0:adc1:4c29:fadb:1dfa talk 5,059 bytes +2 →2NF and candidate keys undo
curprev 00:2700:27, 24 February 2020 2601:198:80:92a0:adc1:4c29:fadb:1dfa talk 5,057 bytes +2 →2NF and candidate keys undo

curprev 19:1019:10, 26 January 2020 Dahmian talk contribs 5,055 bytes +292 Add more logical description to why 1st example isn't 2NF undo Tag: Visual edit

curprev 16:1916:19, 18 December 2019 InternetArchiveBot talk contribs 4,763 bytes +91 Bluelinking 1 books for verifiability.) #IABot (v2.1alpha3 undo

curprev 04:3404:34, 18 September 2019 Oradium talk contribs 4,672 bytes −47 Undid revision 916050548 by 216.162.55.7 (talk) for consistency with the model relation below Hoch SuperBrush isn't needed undo Tag: Undo

curprev 18:3618:36, 16 September 2019 216.162.55.7 talk 4,719 bytes +47 Example of non-2NF data was wrong. undo

curprev 14:5614:56, 25 August 2019 Mikhail Ryazanov talk contribs m 4,672 bytes +4 →Further reading: punct. undo
curprev 14:5614:56, 25 August 2019 Mikhail Ryazanov talk contribs m 4,668 bytes −16 →2NF and candidate keys: MOS:CAPS, fmt. undo

30 October 2024

22 October 2024

30 July 2024

10 July 2024

12 June 2024

30 April 2024

14 March 2024

1 January 2024

24 December 2023

17 November 2023

28 September 2023

17 June 2023

2 April 2023

18 March 2023

14 March 2023

9 March 2023

18 October 2022

12 October 2022

23 March 2022

25 October 2021

28 July 2021

13 July 2021

27 October 2020

3 October 2020

4 May 2020

24 February 2020

26 January 2020

18 December 2019

18 September 2019

16 September 2019

25 August 2019