lampstax Posted August 13, 2009 Share Posted August 13, 2009 I'm studying from the mysql test book and doing the exercises and I run into this question. ( see attached image ). The book claims that this table is in 3NF, but to me, it just seems a little off. Here's the exact text of the answer: - The City table is in the first normal form (1NF) because it doesn't have repeating groups within its rows. - It's in the second normal form (2NF) because it's in 1NF and all its non-index values depend fully on the primary key value (the ID column). - It's in the third normal form (3NF) because it's in 2NF and all its non-index values depend directly on the primary key (and not on some other non-index value). For example, since the only index is the primary key, the id number, I dont see how the value of Country Code 'AFG' depends directly on the ID, and not the Name column. I'm new to normalization so maybe thats why this doesnt look 'normal' to me. Link to comment https://forums.phpfreaks.com/topic/170161-a-bit-confused-on-normal-forms/ Share on other sites More sharing options...
fenway Posted August 21, 2009 Share Posted August 21, 2009 So you're questioning the 2NF? Link to comment https://forums.phpfreaks.com/topic/170161-a-bit-confused-on-normal-forms/#findComment-903188 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.