The first five links in this list are useful in relearning relational design and implementing normalization.
Multiple Tables and Table Occurances (TOs) would be expected in a database your simple description describes.
It's possible to make a copy of your layout and set up the copy to refer to a new table if the field names in the new table are identical to those in the original table. (After this process is done, you can go back and modify field names.) FileMaker advanced can copy and paste table and field definitions so if I were you, I'd beg, borrow or steal the funds needed to get FileMaker Advanced if you don not already have a copy as it will save you hours of time doing this. (Do this on a COPY of your original file so that you can revert back to the original if you mess up.)
If you try to update your existing layout to refer to a new table, you have to update each field and portal on the layout individually, which can take a lot more time to do.
See this thread for how to duplicate a layout: Importing Layouts