Name: Anonymous 2013-01-24 13:13
So I'm making the design for an application system and not sure if it's appropriate to create a new table.
Basically we have the client and all his base information. then we have other things such as his assets which if made into their own table would just be 1 line per applicant but if it's put into the general client table there may be many nulls and yet Normal Form is not violated in either scenario.
Any one have any good rule of thumb for this kind of thing?
Basically we have the client and all his base information. then we have other things such as his assets which if made into their own table would just be 1 line per applicant but if it's put into the general client table there may be many nulls and yet Normal Form is not violated in either scenario.
Any one have any good rule of thumb for this kind of thing?