Fill This Form To Receive Instant Help
Homework answers / question archive / 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
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.
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
7. Data stored in only one place
8. Less storage space required
Disadvantages:
If you are using only a single table then depending on your structure and amount of data in that table you will need to duplicate rows to get in new data that you want to enter. If you use a normalized form then you are saving on space but depending on the complexity of the normalization you may make it less efficient.
Complicated data structure due lot of tables.
Maintaining data integrity is very difficult.
Writing too many tables slows down the system.
Not suitable for applications where you want to store data.(not required for later querying, or other data manipulations.)
Scenario where you need multiple tables:
Using multiple tables in web page design is good because the page will load the data from the top table down.(this is title table just has just title and short description of page.)
This way you can read the content that is first visible at the top of the screen instantly instead of waiting for the entire page to load ( All the main content is stored in content Tables and it takes time to retrieve large amount of data).