I mean everything. Once you have everything, bring it back, and create one huge table. From there, break that table down to 1NF, then 2NF, and so on. Go back over each table, and make sure they all work together, and are all 4NF tables. If they aren't, then it can be assured the tables will suffer problems in the future.
Quality is in the design.
And for those people who know, this helps comply with Codd's first 2 rules for a truly relational database system. Send Feedback Print Article Email Article Written by Jason Lotito . Jason is the webmaster for NewbieNetwork.net , where those who can, teach, and those who can't learn. Focusing on the newbie's of the net, NewbieNetwork is expanding to help newbie developers learn code. The book version covers more advanced topics such as the storage of binary data in MySQL, and cookies and sessions in PHP, and comes complete with a set of PHP and MySQL reference tables that include PHP and MySQL syntax, functions, column types and more.