It really seems that the design is incorrect. The first thing you must understand is that the data is in no order. Another thing is that related data is stored in a single row (if it applies to single entity) or is joined by a reference when the data is spread to separate entities.
I think that the best advice at this point is to encourage you to get to know 3rd normal form (see
http://en.wikipedia.org/wiki/Third_normal_form[
^])
One easy way is to start from
http://www.tutorialspoint.com/sql/sql-rdbms-concepts.htm[
^] and have a look at database normalization. There's a tutorial which wil guide you through first, second, and third normal forms. In my opinion this is what you probably should use in your situation.
Submit an article or tip