Question

why it is preferable to have multiple table in DBMS​

Answer 1

Answer:

Basically a single table is good when data is one-to-one. When you have thousands of rows and columns of data, where the data is one-to-many, multiple tables are better to reduce duplicate data.

Answer 2

Basically a single table is good when data is one-to-one. When you have thousands of rows and columns of data, where the data is one-to-many, multiple tables are better to reduce duplicate data.