Explore BrainMass

Explore BrainMass

    Advantages and Disadvantages: Creating Multiple Tables

    Not what you're looking for? Search our solutions OR ask your own Custom question.

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    What are the advantages and disadvantages of creating and using multiple tables?

    © BrainMass Inc. brainmass.com March 6, 2023, 1:45 pm ad1c9bdddf

    Solution Preview

    Using multiple tables you can avoid the problems faced by creating a flat-file database. A flat file database is a database designed around a single table. containing all the information with fields representing all the parameters. Probelms:
    1) A flat file may contain many duplicate fields
    2) If you decide that one particular field is no longer necessary or you need to add another field then you are in trouble.
    3) If you decide ...

    Solution Summary

    The text addresses comparative advantages and disadvantages of creating and using multiple tables in a relational database management system (RDBMS).