What are the advantages and disadvantages of creating and using multiple tables?© BrainMass Inc. brainmass.com May 20, 2020, 1:19 pm ad1c9bdddf
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 ...
The text addresses comparative advantages and disadvantages of creating and using multiple tables in a relational database management system (RDBMS).