Explore BrainMass
Share

advantages and disadvantages of working with 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 working with multiple tables? Present an example of a situation where multiple tables would be appropriate in an application and discuss why this approach is needed in this scenario.

© BrainMass Inc. brainmass.com March 21, 2019, 1:39 pm ad1c9bdddf
https://brainmass.com/computer-science/web-design/advantages-disadvantages-working-multiple-tables-102332

Solution Preview

Please see the attached file.

Advantages:
1. Querying of data is very easy.
2. Speed of data retrieval is fast compare to single table.
3. You can add tables containing new information without modifying the structure of your existing tables.
4. Access to a small table is more efficient than an access to a large table.
5. Easier data modification
6. Easier data lookup ...

Solution Summary

The advantages and disadvantages of working with multiple tables are noted.

$2.19