Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

www.xxxcon.mvn, www.xxxcon, error expect exactly 2 parameter, procmail msmtp, yxxxcom, mesg: ttyname failed: Unpassender IOCTL (I/O-Control) für das Gerät,, ora-65280, wwww.xxxmo, wwwxxx.cko



#1: blank columns or separate tables

Posted on 2007-09-07 00:01:17 by Pasquale

I have a form with 8 fields, 4 of which are required and 4 are not.
Usually if a field isn't required I would create a separate table for it
rather than having a blank value in the table where required values
would go. In this case, I'm not sure if I should put all the not
required fields in one table or separate tables. Since any one of them
can be or not be blank.

I'm trying to find a balance between normalization and practicality for
the database, as well as programming.

So, are columns with blank values acceptable to a certain number? Are 4
separate tables too many, so that there aren't any blanks in a column if
they were in one table?


Report this message