Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

wwwxxxAPC, How to unsubscrube from dategen spam, WWWXXXAPC, docmd.close 2585, WWWXXXDOCO, nu vot, dhcpd lease file "binding state", WWWXXXDOCO, how to setup procmail to process html2text, how to setup procmail html2text

Links

XODOX
Impressum

#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?

Thanks,
Pasquale

Report this message