I'm all for 3NF but if you are making a postal address table and you want to split the states and cities out of the same table, even though they will almost always be used together, that's just dumb IMHO. You shouldn't have 3NF just for the sake of having it, you should use it if it makes sense.
On Thursday, September 13, 2012 10:38:05 AM UTC-7, Andrew W wrote: > > Yes option 1 sounds right. > Otherwise you're entering 4th normal form territory > http://en.wikipedia.org/wiki/Fourth_normal_form > There may be many ways to do things in web2py, but you should still have a > good database design. --
