Database Advantages Multiple Tables

[G. Kushal]

I want to create a data base directory in my directory. Now I i am bit confuse between adding table or not. does adding more table will makes my database more complex to use. I want to know is it necessary to create table in it. if yes then what are the advantages and disadvantages of the same. In DBMS what is the importance of tables...???

[Zecho]

Weather making database relationship? If it is thus, the definition of the relations between the objects is much more easy and intuitive the use of multiple tables. Also aid to avoid that the superfluous data.

[kelfro]

One of the advantages of the use of multiple tables is that you can add the tables that the new information without modifying the structure of the existing tables contains. For example, to add information of lists, a new table for the data base is added where the first column contains the identification of the employee and the columns contain the present wage, the previous wage, the advantage payment, and 401 (k) percent. In addition, an access to a small table is more efficient than an access to a great table. Therefore, if it updates the direction of the street of an employee, the table of directions is only updated, without having to accede to any other table in the data base.

[Praetor]

Advantages:

• Database Structure is Independent.
  
  
• Database access is limited.
  
  
• It is easy to simplify the multiple table to make single virtual table.
  
  
• Gives real time data.