Developers and Basic Database Design


	Developers and Basic Database Design

travislaborde

5-9-2007 7:29 AM

304 views

tags:

programming

travislaborde says:

I'm not sure how much of my "audience" needs to read this, but... I think it is well written. It's all about the database baby!

Add a Comment

Login to Comment. Not a member yet? Sign up

View the Top Clips from May 9, 2007

Embed This Clip In Your Site...

<div style="margin: 12px 0px; font-family: arial; color: #333333; background: #ffffff; border: solid 4px #e5e5e5; width: 100%; clear: left;"><div class="CM_CTB_Content_Wrap" style="margin: 0px; padding: 0px;background-color: #ffffff;"><div style="border-bottom: solid 1px #dcdcdc; white-space: nowrap; margin-bottom: 8px; background-color: #eeeeee ;background-image: url(http://www.clipmarks.com/images/source-bg.gif); background-repeat: repeat-x; height: 24px; line-height: 24px; vertical-align: middle; padding-bottom: 4px; color: #666666; font-size: 10px;" ><a href="http://clipmarks.com/clip-to-blog/" title="see clips that are hot right now"><img src="http://content.clipmarks.com/blog_embed/2f854840-2a1e-4854-9389-d8c21df4443c/D733691C-7E6C-4225-BFCA-CE5E06C63670/" alt="" width="19" height="19" border="0" style="vertical-align: middle; margin: 0px 4px; display: inline; border: none; float:none;" /></a>clipped from <a title="http://blog.donnfelker.com/2007/05/03/DevelopersAndBasicDatabaseDesign.aspx" href="http://blog.donnfelker.com/2007/05/03/DevelopersAndBasicDatabaseDesign.aspx" style="font-size: 11px;">blog.donnfelker.com</a></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://blog.donnfelker.com/2007/05/03/DevelopersAndBasicDatabaseDesign.aspx"><H1><A href="http://blog.donnfelker.com/2007/05/03/DevelopersAndBasicDatabaseDesign.aspx" rel="bookmark" class="TitleLinkStyle">Developers and Basic Database Design</A></H1></blockquote><div style="height: 2px; font-size: 2px; background: #dcdcdc; border-bottom: solid 1px #f5f5f5; margin: 2px 4px;"></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://blog.donnfelker.com/2007/05/03/DevelopersAndBasicDatabaseDesign.aspx"><FONT size="3">So, why is lacking Database design knowledge a bad thing?</FONT></blockquote><div style="height: 2px; font-size: 2px; background: #dcdcdc; border-bottom: solid 1px #f5f5f5; margin: 2px 4px;"></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://blog.donnfelker.com/2007/05/03/DevelopersAndBasicDatabaseDesign.aspx"><FONT color="#ff0000">A great application can not cover up a poor data foundation.</FONT></blockquote><div style="height: 2px; font-size: 2px; background: #dcdcdc; border-bottom: solid 1px #f5f5f5; margin: 2px 4px;"></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://blog.donnfelker.com/2007/05/03/DevelopersAndBasicDatabaseDesign.aspx"><P>Example 1 - <BR />Client: I need you add another contact record to the "ACME Corporation". <BR />You then look at the database, and notice that the Organization table schema looks like this: </P></blockquote><div style="height: 2px; font-size: 2px; background: #dcdcdc; border-bottom: solid 1px #f5f5f5; margin: 2px 4px;"></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://blog.donnfelker.com/2007/05/03/DevelopersAndBasicDatabaseDesign.aspx"><P>Organization<BR />--------------------------------<BR />Organization_Id  int<BR />Organization_Name varchar(100) <BR />Org_Contact_Name nvarvhar(100)<BR />Org_Contact_Phone nvarchar(50)<BR />Org_Contact_Email nvarchar(100) <BR />... (other columns ommitted for example use)</P></blockquote><div style="height: 2px; font-size: 2px; background: #dcdcdc; border-bottom: solid 1px #f5f5f5; margin: 2px 4px;"></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://blog.donnfelker.com/2007/05/03/DevelopersAndBasicDatabaseDesign.aspx"><P>Organization<BR />--------------------------------<BR />Organization_Id  int<BR />Organization_Name varchar(100) <BR />Org_Contact_Name nvarvhar(100)<BR />Org_Contact_Phone nvarchar(50)<BR />Org_Contact_Email nvarchar(100) <BR />Org_Contact_Name2 nvarvhar(100)<BR />Org_Contact_Phone2 nvarchar(50)<BR />Org_Contact_Email2 nvarchar(100) <BR />... (other columns ommitted for example use)</P></blockquote><div style="height: 2px; font-size: 2px; background: #dcdcdc; border-bottom: solid 1px #f5f5f5; margin: 2px 4px;"></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://blog.donnfelker.com/2007/05/03/DevelopersAndBasicDatabaseDesign.aspx"><P><STRONG>The Wrong Way</STRONG> (You'd be surprised how many times I've seen this. Which is the reason for this post.) </P></blockquote></div><div style="margin: 0px 6px 6px 4px;"><table style="font-size: 11px;border-spacing: 0px;padding: 0px;" cellpadding="0" cellspacing="0" width="100%"><tr><td style="background:transparent;border-width:0px;padding:0px;">&nbsp;</td><td align="right" style="background:transparent;border-width:0px;padding:0px;width:107px" width="107"><a href="http://clipmarks.com/share/D733691C-7E6C-4225-BFCA-CE5E06C63670/blog/" title="blog or email this clip"><img src="http://content8.clipmarks.com/images/c2b-foot.png" border="0" alt="blog it" width="107" height="17" style="border-width:0px;padding:0px;margin:0px;" /></a></td></tr></table></div></div>

Clipmarks: Home; New Clips; Top Clips; Dashboard

Popular Topics: News; Life; Science; Technology; Entertainment

Get Started: Sign Up; Install Clipping Tool; How Clipping Works; Clip-to-Blog™; ClipSearch

Tools and Resources: FAQ; ClipWeek; Top Clippers; Top Tags; Site Map

About Clipmarks: About Us; Contact; Blog; Copyright; Privacy; EULA

Search Options

Related Clips

More clips from travislaborde

Today's Top Clips