Explore BrainMass
Share

Explore BrainMass

    Advantages and Disadvantages: Creating Multiple Tables

    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 May 20, 2020, 1:19 pm ad1c9bdddf
    https://brainmass.com/computer-science/databases/advantages-and-disadvantages-creating-multiple-tables-46587

    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).

    $2.19

    ADVERTISEMENT