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.2-3 paragraphs in your own wordsplease site references
HiCustomerThank you for the question. Can you please give me some more context around this question? Is this for a programming course? If so, which course are you taking? I look forward to your reply. Thanks again,
It is for a visual basic.NET course
Thanks for the reply. Is there any kind of table in particular that you have been studying? Are you working with data tables (native .NET), MS Access tables (SQL), etc...?
database tables, access tables
Thanks for the reply.In a VB (.NET) application, the use of tables can be very powerful. It is a great way to organize data and allows you flexibility and control over the way your application accesses the database table. Using VB.NET, it is very simple to read data from tables, and to append data to tables in the application. Using multiple tables gives you the ability to present your data in a more granular form, however the ability to utilize the data from multiple tables can still be leveraged by joining related data items across tables.In a scenario where you are building an HR (Human Resources) application, it is not practical to maintain all of the data in a single table, as you are likely to have an "Employees" table, a "Departments" table, a "Salary" table, etc... The advantage of having the data in multiple tables is that it allows any developer to easily identify the structure of the application's back-end. If all the data was placed in a single table, the developer would be limited to how the data is inserted and retreived by the application.The disadvantage of using multiple tables is that it requires the developer to learn the table schema (format/structure) before they are able to effectively begin any development efforts on a project. A certain level of database administration knowledge is also required when using multiple tables, as optimization becomes a factor when building large applications. Indexes, primary/foreign keys, and data integrity are all important for a well designed application. Overall, it is a very common practice for any experienced developer to utilize multiple tables within an application.Please let me know if you have any questions and I will be happy to assist further. Thanks again!
Years of professional experience in C++, Visual Basic, .NET, Java, DB2, Oracle, SQL Server, PL/SQL