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?
Name:
Anonymous2013-01-24 13:20
go to r/programming/ if you actually need help, here are just BBC experts
Name:
Anonymous2013-01-24 13:20
Get a DB consultant and give him some big money. Then if he doesn't take a crap on your idea and your face, he'll design an architecture that will stand the test of time. This would be a moment when you should activate the few mirror nerves your parents bestowed on your sorry self, so do your best standing by ready to gulp up as much as you can from what ever he is doing.
Name:
Anonymous2013-01-24 15:25
Okay brainstorm with me /prog/ do I want an individual table for each school and then have a sub table saying which school each kid is being assigned to. The benefits of that is that it is a speedier look up however it's more taxing when filling out the application as when someone types in and submits the school, will have to do a look up if the school exists get the id number and then assign it if it does if not I have to crate it. This also allows for much more expandibility as I can reference each school and it's assets by creating separate tables linked with the school.
On the other hand if I just keep child and school information on the same line insertion is easy and performance look up times shouldn't be anything remotely noticeably different, but I do lose the ability to categorize the schools in any effective matter.
OP, really, you are the one being asked for this job. Analyze your Independent variables, which are you tables, and your dependents, the actual contents of a table. Then make test trials with graph of your dependents, to learn what needs to be prioritized. And finally design your database what you optimize from results. It begs the question if you have ever done any laboratory with reports.