This week, we talk about 2NF, 3NF and a bit about normalization vs. denormalization.
Call for papers for Percona Live: MySQL Conference & Expo 2012 is open until Monday, December 5th. The MySQL Conference & Expo is Tuesday April 10 - Thursday, April 12, 2012 in Santa Clara, CA. To submit a paper, first register as a speaker at http://www.percona.com/live/mysql-conference-2012/user/register and then go to My Account -> Submit Proposal.
OurSQL episode 7, which goes over first normal form (1NF).
Schema of airport codes, cities and countries in 2NF:
YOW - Ottawa - Canada
EWR - Newark - USA
BOS - Boston - USA
LHR - London - England
SEA - Seattle - USA
Schema of airport codes, cities and countries in 3NF:
YOW - Ottawa
EWR - Newark
BOS - Boston
LHR - London
SEA - Seattle
And the city table would have entries like:
Ottawa - Canada
Newark - USA
Boston - USA
London - England
Seattle - USA
Brian K. Jones writes about denormalizing, but only if you have to, in A couple of MySQL performance tips.
Manual page for Percona patched MySQL variable use_global_long_query_time
Where you can see us
Boston MySQL User Group on Monday, November 14th at 7:00 PM where Mike Frank of Gazzang will present "MySQL Encryption".
The November Seattle MySQL User Group on Thursday November 10th from 7 - 9pm, an unusual day of the week for this meetup, but Sarah moved it to accommodate Ori Herrnstadt, CTO Akiban talking about Renormalize - Solving Performance Problems in MySQL Without Denormalization.
The December Seattle MySQL User Group on Monday December 5th from 7 - 9 pm where Ivan Zoratti of SkySQL will present "MySQL HA Revisited".