List:General Discussion« Previous MessageNext Message »
From:Mahmoud Badreddine Date:April 14 2005 6:54pm
Subject:Database design question
View as plain text  
Hello,
I have two questions:
I would like to know whether I am violating the principle of atomicity in 
doing the following:

I have a form which has a field with the following options: Choice1, choice2 
and choice3.
Each of the above choices have two further subchoices : subChoice1, 
subchoice2.

so in my form I have a pull-down list and these are the choices I have:
choice1-subchoice1
choice1-subchoice2
choice2-subchoice1
....
....
and so on.

Are these values atomical?

My other question is what are the repercussions of not putting a table in 
2nd and 3rd Normal Form.
Thank you.


-- 
-Mahmoud Badreddine

Thread
Database design questionMahmoud Badreddine14 Apr
  • Re: Database design questionPeter Brawley14 Apr