August 27, 2014
Hot Topics:
RSS RSS feed Download our iPhone app

Visual Basic Database Tutorial - Part 5

  • November 19, 2002
  • By Karl Moore
  • Send Email »
  • More Articles »

Let's face it. There are three types of people in this life; the good, the bad and the ugly.

You and I fall into the first bracket; the stunningly good looking and wonderfully intelligent group. The Editor falls into the second band. And the average database design falls into the last, rather disgusting category.

This week, I'd like to give your database design a makeover and move it straight into the upper echelons of the "Good".

So lets start with a case study. Sit back and imagine we're running a pet hospital. You need to record all the information about me. And my pet iguanas. And my pet cow.

Based on the information I've given you already, you'd probably store my name and address all on one row. And on that same line, you'd add details of my pet. Your basic table might look like this:

IDNameAddressPetBreed
121Karl MooreThe InfirmaryWigglesIguana

But what about my other pet iguana, Green Thing?

Hmm, I guess you could change your table to look like this:

IDNameAddressPetBreedPetBreed
121Karl MooreThe InfirmaryWigglesIguanaGreen ThingIguana

That's brilliant. Well, in a kind of non-brilliant way.

You see, you've forgotten my third iguana, Strangely Brown. Oh dear.

So how do you get around this? Sure, you could add a third column. But then you've forgotten about my pet cow, Daisy. Doh!





Page 2 of 6



Comment and Contribute

 


(Maximum characters: 1200). You have characters left.

 

 


Sitemap | Contact Us

Rocket Fuel