AnsweredAssumed Answered

Single Table Database to Multiple Tables?

Question asked by MegS on Mar 25, 2013
Latest reply on Mar 25, 2013 by philmodjunk


Single Table Database to Multiple Tables?



     I inherited a single table database at work that includes about 80 fields by this point.  I've been learning more about databases and how they work it seems like it might be better to have a database with multiple tables for different kinds of information.  I have two questions:

     1. Is it possible to separate out the fields into multiple tables?

     2. What are the advantages and disadvantages to doing this if it is possible?  

     Thanks a lot.