Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

w2ksp4.exe, WwwxxXdbf, procmail "FROM_MAILER" patch, Use of assignment to $[ is deprecated at /usr/local/sbin/apxs line 86. , wwwxxx vim, mysql closing table and opening table, 800c5000, setgid operation not permitted, pciehp: acpi_pciehprm on IBM, WWWXXX.DBF



#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