QUESTION POSED ON: 06 September 2005
I have a Web-based application that creates mini sites for people. A user will sign up for the site with some basic personal information and then, once approved, they will add more information (one to zero or one). For example, bio short description, bio long description, head shot (.jpg) and work description.
Should I use nullable fields in the table containing the user's name, or normalize into other tables (bio, images, work)? If I choose the later, then do I create the records with null fields before they enter data, or do it on the first "update"?
|
