Advantages and Disadvantages: Creating Multiple Tables
Not what you're looking for? Search our solutions OR ask your own Custom question.
What are the advantages and disadvantages of creating and using multiple tables?
© BrainMass Inc. brainmass.com March 6, 2023, 1:45 pm ad1c9bdddfhttps://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.49