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.