{"id":25,"date":"2006-08-30T13:45:00","date_gmt":"2006-08-30T22:45:00","guid":{"rendered":"http:\/\/localhost\/wordpress\/?p=25"},"modified":"2007-01-23T13:21:02","modified_gmt":"2007-01-23T22:21:02","slug":"a-simple-intro-to-database-normalization","status":"publish","type":"post","link":"https:\/\/www.evardsson.com\/blog\/2006\/08\/30\/a-simple-intro-to-database-normalization\/","title":{"rendered":"A simple intro to database normalization"},"content":{"rendered":"<p>I found a very clear, well-written introductory <a href=\"http:\/\/www.devshed.com\/c\/a\/MySQL\/An-Introduction-to-Database-Normalization\/\">example<\/a> to database normalization on devshed. Although it is in the MySQL portion of the site, it applies equally well across the board to other RDBMSs.<\/p>\n<p>To get more details on normalization, the normal forms, and general good database development in general, check out <a href=\"http:\/\/www.amazon.com\/Database-Design-Mere\/dp\/0201752840\/sr=8-1\/qid=1156966801\/ref=pd_bbs_1\/002-0285788-0488009?ie=UTF8\">Database Design for Mere Mortals: A Hands-On Guide to Relational Database Design, Second Edition<\/a> by Michael J. Hernandez. Without a doubt the most useful db development book I&#8217;ve ever laid my hands on.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I found a very clear, well-written introductory example to database normalization on devshed. Although it is in the MySQL portion of the site, it applies equally well across the board to other RDBMSs. To get &hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[40,15,13],"tags":[177,152,150],"class_list":["post-25","post","type-post","status-publish","format-standard","hentry","category-best-practices","category-database","category-mysql","tag-best-practices","tag-database","tag-mysql"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/pxT7i-p","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.evardsson.com\/blog\/wp-json\/wp\/v2\/posts\/25","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.evardsson.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.evardsson.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.evardsson.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.evardsson.com\/blog\/wp-json\/wp\/v2\/comments?post=25"}],"version-history":[{"count":0,"href":"https:\/\/www.evardsson.com\/blog\/wp-json\/wp\/v2\/posts\/25\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.evardsson.com\/blog\/wp-json\/wp\/v2\/media?parent=25"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.evardsson.com\/blog\/wp-json\/wp\/v2\/categories?post=25"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.evardsson.com\/blog\/wp-json\/wp\/v2\/tags?post=25"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}