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
Please see the attached file.
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 ...
The advantages and disadvantages of working with multiple tables are noted.